Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / API is not working...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

API is not working...

(0) ShareShare
ReportReport
Posted on by Hedi Daneels 477

Hi All,

I am trying to run a simple query with the api, but it seems to only work on default fields, which is... 

api/data/v9.0/CUSTOMTABLE1/?$apply=groupby((RELATIONFIELDTOTABLE2/FIELD_FROM_TABLE2),aggregate(FIELD_FROM_TABLE_1 with sum as total))

based on this: 

opportunities?$apply=groupby((parentaccountid/name),aggregate(estimatedvalue with sum as total))

from here: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-data-web-api

The thing is, it only works with original tables. With custom tables it says :

   "code": "0x80041103",
        "message": "'CUSTOMTABLE1' entity doesn't contain attribute with Name = 'RELATIONFIELDTOTABLE2' and NameMapping = 'Platform'. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=53221094, MinActiveRowVersion=53221094, MetadataInstanceId=44365775, LastUpdated=2021-04-18 08:52:58.400"

Any work around? Or raison why we are not allowed to use this on custom tables?

Regards

  • Hedi Daneels Profile Picture
    Hedi Daneels 477 on at
    RE: API is not working...

    Quick question that will help me a TON

    Why does this work:

    api/data/v9.0/opportunities?$apply=groupby((parentaccountid/name))

    But not this:

    api/data/v9.0/contacts?$apply=groupby((parentcustomerid_account/name))

  • Hedi Daneels Profile Picture
    Hedi Daneels 477 on at
    RE: API is not working...

    Hi,

    I used the metadata to build my query, and that is also why we get this specific message, he sees the mapping. He just doesnt want to use it.

    Regards

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: API is not working...

    Hi,

    Thank you for your query.

    Aggregates are not limited to out-of-the-box tables.

    Please make sure relationship and fields name are correct.

    If you are not sure what is the name of the field/property, Get a record using Web API and see the names.

    You can also download the OData metadata for more details:

    How to download metadata file From CRM? - Microsoft Dynamics CRM Community

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans