I noticed that the new Xrm.WebApi has an option to make a CRUD request. So far i only saw examples of executing an action and function but no CRUD. I know the api has specific method for each operation but would still like to know how to make a CRUD operation with the execute/executeMultiple methods.
*This post is locked for comments
using the new v9 xrm.webapi there are 2 declared ways of performing CRUD operations, one is using the execute command which is not documented and doesnt work perfectly as i stated earlier. the other way is using a specific method such as retrieceRecord, retrieveMultipleRecords, createRecord...
I just opened an issue with MS documentation, let’s see if we are getting any updates on code samples for operationtype : 2 (CRUD)
Hi there
Are you saying that the retrieveRecord can be made to work?
I am about to try this so didn't want to waste a lot of time over it
Kind Regards
Ian
Interesting, I had not taken a look at the source. I am wondering if the API simply not complete which is why it has not been fully documented. A quick look at the October 2018 release notes didn't show anything about Web API updates, but that document does not dive into a lot of detail.
That might be a question for the product team, such as what is the timeline for CRUD support in Web API. I'll reach out to some colleagues that have access to the Microsoft internal KB for this kind of thing!
I too had to reverse engineer the script, and while i didnt check it all the way, it appears that there are several bugs. i only tried retrieve so far. in order to do that you need to specify
Share
Report
All responses (
Answers (
this.entityReference = {
"etn": "incident",
"id": "85D8D20D-3C93-E811-A952-000D3AB0FC6E"
};
and add this as a parameter. this.columns is an array of the fields you want to query (schema name).
first of all in the developers guide it says to specify the operation name but the code doesnt accept "retrieveMultiple":
second, what i found out was happening is that for each requested field there is a match to see if it is of type "lookup"/"owner"/"customer" but the type that is retrieved from the metadata is in fact "Lookup" and thus no such field exists for the query (if there is a match it returns _field_value in order to add it to the select statement). there is also no way to add filter/expand statements (althouth the script is looking for it but always on an empty array). I still didnt have the time to investigate the other operations.
It does not look like the execute() methods support anything outside of Actions and Functions.
Check out this post by Andrew Butenko and his follow up: butenko.pro/.../microsoft-dynamics-365-v9-0-usage-of-new-oob-webapi-functions-part-2
He talks briefly about having to reverse engineer the script to figure it out!
i am talking about the execute method https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/clientapi/reference/xrm-webapi/execute
according the api :
0: Action1: Function2: CRUD0: Unknown1: PrimitiveType2: ComplexType3: EnumerationType4: Collection5: EntityTypebut there is no refrence in the parameterTypes object on how to set the request, where do i put my retrieve query for example?
Hi golan,
These articles cover Xrm.WebApi operations in depth.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156