Xrm.WebApi.online.retrieveMultipleRecords no response

(0) Share

Report

Posted on by EKL

Hi ,

I am unable to get any response from the Xrm.WebApi.online.retrieveMultipleRecords.using CRM Rest builder.

Below is the snippet

Xrm.WebApi.online.retrieveMultipleRecords("appointment", "?$select=subject,activityid,_createdby_value,createdon,scheduledend,scheduledstart&$filter=_regardingobjectid_value eq '" + opportunityId + "'and statecode ne 1 and statecode ne 3 and contains(subject, 'Week')").then(

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Community Member on at

Like (2)

Report
RE: Xrm.WebApi.online.retrieveMultipleRecords no response

Hi EKL,

I have created one appointment as your conditions:

(1) Regarding field related to the opportunity--01(3e6166e1-c2c9-eb11-bacc-002248096605)

(2) State is open --statecode is 0

(3) Subject field contains 'Week'.

Then i used same filter to retrieve appointments:

Xrm.WebApi.online.retrieveMultipleRecords("appointment", "?$select=activityid,_createdby_value,createdon,scheduledend,scheduledstart,subject&$filter=_regardingobjectid_value eq 3e6166e1-c2c9-eb11-bacc-002248096605 and statecode ne 1 and statecode ne 3 and contains(subject, 'Week')").then(

Result:

So you need to check all appointments to see if any exist that meet all the conditions.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
EKL 10 on at

Like (0)

Report

RE: Xrm.WebApi.online.retrieveMultipleRecords no response

Thank you, Can you please let me know the code you used to retrievemultiple or how to do via CRM REST Builder.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
RE: Xrm.WebApi.online.retrieveMultipleRecords no response

Hi EKL,

I have built api in CRM REST Builder as following screenshot:

Then i got following code:

Xrm.WebApi.online.retrieveMultipleRecords("appointment", "?$select=activityid,_createdby_value,createdon,scheduledend,scheduledstart,subject&$filter=_regardingobjectid_value eq 3e6166e1-c2c9-eb11-bacc-002248096605 and statecode ne ne and statecode ne ne and contains(subject, 'Week')").then( function success(results) { for (var i = 0; i < results.entities.length; i ) { var activityid = results.entities[i]["activityid"]; var _createdby_value = results.entities[i]["_createdby_value"]; var _createdby_value_formatted = results.entities[i]["_createdby_value@OData.Community.Display.V1.FormattedValue"]; var _createdby_value_lookuplogicalname = results.entities[i]["_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname"]; var createdon = results.entities[i]["createdon"]; var scheduledend = results.entities[i]["scheduledend"]; var scheduledstart = results.entities[i]["scheduledstart"]; var subject = results.entities[i]["subject"]; } }, function(error) { Xrm.Utility.alertDialog(error.message); } );

But i found some errors in code(I'm not sure what the reason is), so i can't execute it in CRM REST Builder.

So i copy the URL:

Change the errors:

orgxxxxxxx.crm.dynamics.com/.../appointments

Paste it to the URL bar of the browser, then you can get response:

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
AriaConsulting 2 on at

Like (0)

Report

RE: Xrm.WebApi.online.retrieveMultipleRecords no response

, how do you come up with this so fast?? Wow!

Was this reply helpful? Yes No