Query data using the Web API - query data from Adaptive Planning (ERP) - got error 404

(0) Share

Report

Posted on by AvaGrace

Any help is greatly appreciated!!!

Testing the connection using following URL

"https://instanceName.api.crm3.dynamics.com/api/data/v9.2/account?$select=name&$top=1";

the table account DOES exist but return 404

Have I constructed the URL wrong? Do I need the instance reference ID in the URL?

First time query data from CRM.

Thanks,

Grace

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Sourav0147 115 on at

Like (0)

Report

Hi

try below url.

https://instanceName.api.crm3.dynamics.com/api/data/v9.2/accounts?$select=name&$top=1

I have just added s in accounts i.e Plural Name. This should work.

Also, if you are not sure about the entity name then call this url to check the name of the entity which is used in API

https://instanceName.api.crm3.dynamics.com/api/data/v9.2

Was this reply helpful? Yes No
Guido Preite 54,086 Moderator on at

Like (1)

Report

if you need assistance on building Web API queries you can use my tool Dataverse REST Builder

hope it helps

Was this reply helpful? Yes No
AvaGrace 10 on at

Like (0)

Report

Sourav,

Thank you very much for your answer. It works. However it is kind of strange since I downloaded the OData Metadata file under Developer Resources. In the XML file the entity name is account. I did use accounts and I got the data in!!!

Please see the XML file here: just wondering why

<EntityType Name="account" BaseType="mscrm.crmbaseentity">

<Key>

<PropertyRef Name="accountid"/>

</Key>

<Property Name="address1_telephone2" Type="Edm.String" Unicode="false"/>

<Property Name="altus_oecdcode" Type="Edm.String" Unicode="false"/>

Grace

Was this reply helpful? Yes No
Verified answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

this is the Docs regarding the name to use:

docs.microsoft.com/.../web-api-types-operations

"This is the name of the entity set. This data is from the EntityMetadata EntityType/ EntitySetName property for the entity."

Was this reply helpful? Yes No
AvaGrace 10 on at

Like (0)

Report

Thank you Guido for the information!!

Was this reply helpful? Yes No
AvaGrace 10 on at

Like (0)

Report

Thanks again. I tried the link instanceName.api.crm3.dynamics.com/.../v9.2

yes I see the correct names used in API.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Query data using the Web API - query data from Adaptive Planning (ERP) - got error 404

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Query data using the Web API - query data from Adaptive Planning (ERP) - got error 404

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates