Andryhl | 2020-12-16 10:45:44 UTC | #1
Hi, We currently have a Data Action Integration to Dynamics 365 using Get Contact by Phone Number, the purpose is to get the Call Priority back from the CRM which will be used to determining the Queue that the call will be assigned to.
The problem is that this API request search for all records in Dynamics CRM whether it is Active or Inactive. What we are trying to do is to only search / filter for Active Records only? the parameter for Active Record is statecode=0. anyone can help on how to apply the parameter?
{ "requestUrlTemplate": "/api/data/v8.1/contacts?${esc.dollar}select=contactid,parentcustomeridvalue,owninguservalue,firstname,lastname,nickname,sosanswerpriority,telephone1,telephone2,telephone3,mobilephone,emailaddress1,emailaddress2,emailaddress3,address1line1,address1line2,address1city,address1stateorprovince,address1postalcode,address1country&${esc.d}filter=$esc.url($msdynamics.phoneNumberFilter(\"$input.PHONENUMBER\", [\"telephone2\", \"mobilephone\", \"sosothercontact1\", \"sosothercontact2\"]))", "requestType": "GET", "headers": { "UserAgent": "PureCloudIntegrations/1.0" }, "requestTemplate": "${input.rawRequest}" }
Thanks,
Jason_Mathison | 2020-12-16 14:38:17 UTC | #2
Hi Andryhl,
What have you tried that didn't work? It looks like this page gives the syntax for filtering: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/query-data-web-api
--Jason
system | 2021-01-16 14:38:21 UTC | #3
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 9519