web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Unable to get the data...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Unable to get the data from user created entities with GetEntityByODataQuery

(0) ShareShare
ReportReport
Posted on by Mleu 55

Hi All,

I hope you are having a safe and amazing day. I have a requirement where I need to  query the data from user created entities. Currently I am unable to do so and running into an error. It is working for all other entity types like Activities, Intelligence and System via GetEntityByODataQuery.

It is just not possible or do I need to change some settings ?. It says entity data not found and exception culprit as user in the HTTP response. Please help me with this. 

Here's the response I get when I try

HTTP/1.1 404 Not Found
api-supported-versions: 2018-10-01
content-type: application/json; charset=utf-8
date: Wed, 05 May 2021 04:52:30 GMT
transfer-encoding: chunked
x-content-type-options: nosniff
x-ms-request-id: c09dfdb9-d79a-47d6-8cba-b32e5c3adeaa
{
    "httpStatusCode": "notFound",
    "exceptionCulprit": "User",
    "errorCode": "EntityDataNotFound",
    "resultSeverity": "Error",
    "message": "Entity Data not found.",
    "params": {
        "InstanceId": "615ccecc-19dc-472c-9408-8b82xxxxxxxx",
        "EntityName": "CustomerLoyalty"
    }
}

I have the same question (0)
  • John Wiese Profile Picture
    John Wiese Microsoft Employee on at

    What is the query you are making?

  • Mleu Profile Picture
    Mleu 55 on at

    Hey John,

    I am using this HTTP GET request to get the entity data.

    GET api.ci.ai.dynamics.com/.../{relativePath} HTTP/1.1

    the relative path is the entity name correct ?. It is working for all other entity types like Unified, Intelligence, Measures, System except User.

    TL;DR I want to fetch the data from the entity that got created from my uploaded data sources as I have performed joins between different tables and ran power queries in CI.

  • Suggested answer
    John Wiese Profile Picture
    John Wiese Microsoft Employee on at

    Ah, that explains it.  There is no entity "User", the unified profile entity is called "Customer".  That is why you get a 404 Not Found error because it doesn't exist.  You can get the name of the entities within the web interface by going to Data -> Entities in the left hand menu.  In the list you will see the Name column, which you can use with the API.

  • Mleu Profile Picture
    Mleu 55 on at

    Yes, in that list the Entities are further categorized into Activities, Intelligence, Measures, Profiles, Segments, User ( I am trying to fetch the ones listed here) correct ?.

    All others are created based on the actions we perform like Unification, Creating a new segment or measure. But the ones under the User are automatically created whenever we add a new data source under the Data sources section. So I am able to get the data from all entity types using the API except the ones under user.

  • Suggested answer
    John Wiese Profile Picture
    John Wiese Microsoft Employee on at

    Ah, ok, I think I understand.  Those are not available as they aren't necessarily going to exist in the CI Data Lake.  If you bring in the data using "Connect to CDM" or "Connect to CDS" option when bringing in the data then we don't copy the data into the CI Data Lake.  You also should have access to these directly from the same source that CI is getting them from.

  • Mleu Profile Picture
    Mleu 55 on at

    Oh alright. That makes sense. But right now, we performed some joins and modified with power query in CI. It would make the flow much easier if we can access those entities as well. So for now going back to the source data is the only option then I presume.

  • John Wiese Profile Picture
    John Wiese Microsoft Employee on at

    Correct, going to the source would be your only option. I am curious to know what your use case is?  Is there a reason that simply getting the unified customer profile with all the fields in it is not an option for you? 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 208 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 80

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans