CRM 9 - Fetch records from a CRM entity based on ID using JavaScript WebResource

Question

I have a entity with multiple records in it. The entity contains 3 fields Parameter Name, Parameter Value, and Contact ID. Contact ID is a lookup field. There are multiple records for a same Contact ID in my CRM Entity.

Now I want to fetch all Parameter Name and Parameter Value from CRM Entity based on the Contact ID.

I am using following code,

var Query = "$select=vrp_parametername&$filter= vrp_contactid eq '" + contactid + "'";
 XrmSvcToolkit.retrieveMultiple({
    entityName: entity ,  
    odataQuery: Query,
    async: false,
    successCallback: successCallback,
    errorCallback: errorCallback
});

But I am getting following error,

Error has occurred in retrieving Response - Error: 400: Bad Request: No property 'vrp_contactid' exists in type 'Microsoft.Xrm.Sdk.Entity' at position 1

AnkUser · Accepted Answer · 2019-04-05 14:04:58Z

0

Error clearly states that for that particular entity it could not find vrp_contactid field. Why don’t you check if field is available. Try using Crm restbuilder and see which condition attribute is available.

answered Apr 5, 2019 at 14:04

AnkUser

5,5592 gold badges13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Faran Saleem · Accepted Answer · 2019-04-09 06:01:56Z

0

I was mixing the Schema Name with Logical Name in CRM in this case. I was using Schema Name in CRM which was why this error was coming.

What I did was simply used the Logical Name in this case and was able to achieved the desired result.

Thank you all for the help

answered Apr 9, 2019 at 6:01

Faran Saleem

4241 gold badge8 silver badges37 bronze badges

1 Comment

Arun Vinoth PrecogTechnologies Over a year ago

can you put the query you used finally?

Arun Vinoth PrecogTechnologies · Accepted Answer · 2019-04-09 10:56:10Z

0

You should use _vrp_contactid_value

var Query = "$select=vrp_parametername&$filter=_vrp_contactid_value eq '" + contactid + "'";

Update:

You can use the filter using single valued navigation property, refer my blog on same topic. There is another version of this query below:

var Query = "$select=vrp_parametername&$filter=vrp_contactid/contactid eq '" + contactid + "'";

3 Comments

Faran Saleem Over a year ago

But the field name is vrp_contactid

Arun Vinoth PrecogTechnologies Over a year ago

@FaranSaleem community.dynamics.com/365/b/arunvinothdynamicsspot/archive/…

Arun Vinoth PrecogTechnologies Over a year ago

@FaranSaleem see my update, also make sure you close all your SO questions by upvoting/accepting the answer that helped you.

Collectives™ on Stack Overflow

CRM 9 - Fetch records from a CRM entity based on ID using JavaScript WebResource

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related