Customer experience | Sales, Customer Insights,...

When fetching custom entity data "The given key was not present in the dictionary"

(0) Share

Report

Posted on by Muhammad Shuja

Hi,

I am using a web API to get the data of an entity and I am using postman to check the API working.

This is the API is am using:

{{base_url}}/api/data/v9.0/{{custom_entity_plural_name}}

But I am getting following response from the CRM.

{

"error": {

"code": "0x80040265",

"message": "The given key was not present in the dictionary."

.............

}

I am using on-premises version of CRM. Same API is working fine when I try to fetch other entities like accounts, contacts, leads and opportunities.

Screenshot for reference:

Kindly guide me on this.

Thanks & Regards

All responses (10)

Answers (0)

Muhammad Shuja 1 20 on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi,

I am using version 9 of crm dynamics (on premises).
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi,

What version of crm dynamics you have installed?

May be your CRM version is not supported by Dataverse Rest Builder.
Muhammad Shuja 1 20 on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi Bipin,

Also tried with this:
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi,

Not sure why your url says localhost:

It has to be https:\\orgname.domain.com\instancename
Muhammad Shuja 1 20 on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi,

Tried it already.

But getting following errors one by one:

I tried on both Chrome and Edge but same response.

Then I tried on internet explorer, I didn't get any above error in that case, but I get empty screen.
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi,

Download managed solution from below link and install to your on premise instance

github.com/.../releases

This works for on premise instance too.
Muhammad Shuja 1 20 on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi Bipin,

It looks like this solution will work. I tried to install this on my local system and connect it with CRM cloud version and it works fine.

But when I connect this to on-premises CRM. I am facing following issue.

Connection to the CRM is also successful. But getting this error.

I tried to look for the solution but didn't find it yet.

Is there a way if we can install older version of DRB in XrmToolBox.
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi,

Try installing DRB tool on your instance to auto generate the code .

carldesouza.com/.../

You can check the exact URL from this tool.
Muhammad Shuja 5 on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi Matt,

Thanks for the quick response.

I tried with the suggested name "bcp_customerproductss" but get the same response.

Then I executed this endpoint ("crmrooturl/api/data/v9.0") as you suggested.

This is the entity information:

Kindly check this screenshot.

Thanks & Regards
Suggested answer

- Matt Bayes - 890 on at

Like (0)

Report

RE: When fetching custom entity data "The given key was not present in the dictionary"

Hi Muhammad,

The issue usually comes up when the table you are referencing has a different name than what you expect.

The API endpoint references the tables based on their collection name, not their plural name (in most cases it's the same but can be different).

My thought is that instead of "bcp_customerproducts" it might be something like "bcp_customerproductss" because of the way Microsoft builds the collection name. If you wanted to confirm this, you can just open up CRM and navigate to the API endpoint ("crmrooturl/api/data/v9.0") and see if you can locate the "bcp_customerproducts" collection. You can do a search on the webpage (Ctrl + F) and locate it that way.

Send a screenshot of the collection name if it does match what you are searching for, and we can figure out a solution from there.

Thanks!

Matt Bayes