News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... API Query Not Accessib...

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

Suggested answer

API Query Not Accessible in ODATA or Online

(1) Share

Report

Report

Posted on by aqeel2020uae

66

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 4,753 on at

Like (1)

Report

API Query Not Accessible in ODATA or Online

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.
Suggested answer

Mohamed Amine Mahmoudi 9,818 Super User 2024 Season 2 on at

Like (0)

Report

API Query Not Accessible in ODATA or Online

Hi @aqeel2020uae,

You need to use TrackingV2 instead tv2 !

Best regards,

Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans