Microsoft Dynamics 365 | Integration, Dataverse...

How to get all contracts with API

(0) Share

Report

Posted on by Cedric GIRARD

Hello,

I have tried to get all contracts by API with xxx.crm4.dynamics.com/.../contracts but result is :

{"@odata.context":""value":[]}">xxx.crm4.dynamics.com/.../$metadata

Could you help me ?

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Your API query looks good to me.

Please verify if you have read access on Contracts entity. Have you tried running this api query using system admin user.

You don't see any value because either you don't have access to Read Contracts OR you don't have any record in yoru instance.

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report
Please refer below API.

1. If you need entity data(All the records) then refer below API.

GET [Organization URL]/api/data/v9.2/accounts

2. If you need specific record information in specific entity then provide the GUID in 2nd API.

GET [Organization URL]/api/data/v9.2/accounts(b4cea450-cb0c-ea11-a813-000d3a1b1223)

3. if you need specific record information in specific entity(with limited fields) then provide the GUID in 3nd API as well as the logical name of the fields.

GET [Organization URL]/api/data/v9.2/accounts(b4cea450-cb0c-ea11-a813-000d3a1b1223)?$select=websiteurl,name

docs.microsoft.com/.../query-data-web-api

Thank you,

Amit katariya

Was this reply helpful? Yes No
Cedric GIRARD 10 on at

Like (0)

Report

The used user is the global administrator of dynamics 365 and there is 30 contracts saved on the platform... :-(

Was this reply helpful? Yes No
Cedric GIRARD 10 on at

Like (0)

Report

with accounts it is work but not with contracts....

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

Try below

CRM URL/api/data/v9.2/contracts

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

Also you can check out from your browser where you are already logged in with the credentials.

if you will just replace the URL with your URL then it will also work for you.

CRM URL/api/data/v9.2/contracts

Was this reply helpful? Yes No
Luke Jones 20 on at

Like (0)

Report

Hello, I am an associate of Cedric Girard.

I have already tried with our URL and the value is empty but on dynamics 365 we have 30 contracts saved on the platform.

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

Are you an admin or are you able to see this contracts from the advanced find?

because if you are not able see this records then it will be not visible in API result also.

Was this reply helpful? Yes No
Luke Jones 20 on at

Like (0)

Report

I think I'm admin and I can see the contracts from Dynamics 365 in Field service.

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

Like (0)

Report

are you sure is Contract entity and not some other entity that got renamed inside the UI?

if you can find the records with advanced find post here the FetchXML (you can download from the button "Download Fetch XML") inside the FetchXML is written the exact entity name the query is using

or you can get the entityname also from the url of a link to a specific record

Was this reply helpful? Yes No