Small and medium business | Business Central, N...

API Query Not Accessible in ODATA or Online

(1) Share

Report

Posted on by aqeel2020uae

293

Dear Experts.

I am developing 2 queries in Al Language type=API first one is Deployed in BC sandbox and published successfully. I copied 1st Query and Change Object ID Name as common practice and deployed (later it was plan to add filter in 2nd query)

But getting error on accessing 2nd query even tried with different IDS and Name and try to re publish and deploy but still in same error as below.

1st Query in Al Language which is working very well with excel and power bi.

2nd Query copy which is deployed same way and published but not working.

Published in same correct way Query 1 and Query 2. but Query 2 not working in ODATA Feed in excel or power bi.

Thanks in Advance for your precious time.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,449 Super User 2025 Season 2 on at

Like (0)

Report

Hi @aqeel2020uae,

You need to use TrackingV2 instead tv2 !

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,947 Super User 2025 Season 2 on at

Like (1)

Report

The issue likely lies in the uniqueness of EntitySetName, APIGroup, or APIName in the second query. Ensure these values are distinct from the first query. Unpublish the second query, clear cached metadata, redeploy it, and reconnect in Excel or Power BI.

Was this reply helpful? Yes No
aqeel2020uae 293 on at

Like (0)

Report

Dear Khusbu Rajvi and Amine.

EntitySet Name and other parameters are different than Query 1. and i tried the other solution but still not working.

Thanks

Aqeel.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,388 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

How Do I: Create a simple API query and page for PowerBI? – think about IT

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,947 Super User 2025 Season 2 on at

Like (1)

Report

Such strange things—one query is working, and another is throwing an error.

Do one thing: copy the entire query code that is working properly and create new query, then check if it works fine. If it does, then there is likely something messy in the second query.

Was this reply helpful? Yes No