Struggling to use Updatemultiple to update dataverse table

[mhaupt]

Hi there, hoping someone can help a dataverse newbie with an issue.

I cannot get the "updatemultiple" api call to work, despite following article here.  Suspect it might be due to incorrect odata.type.  Note I can successfully retrieve data via api calls from the target table ("mh_glaccounts).

My url for the POST call is: 

 https://orgxxxxx.crm.dynamics.com/api/data/v9.2/mh_glaccounts.UpdateMultiple

My json data being passed includes all the table's fields, plus an addition "@odata.type".    But I've essentially guessed the value for that data.type, as I don't know how to retrieve it.

JSON data = {'Targets': [
{'@odata.etag': 'W/"3200503"', 'mh_glaccountid': 'fd08e026-e5bf-ee11-9079-000d3a8f5f4d', ...,
'@OData.type': 'Microsoft.Dynamics.CRM.expando'} ...]}

The POST command seems to execute OK. its just that the dataverse table doesn't actually change 😞

[Stevieed]

Not exactly sure about what is required in your updateMultiple request body, but you may want to check out the REST builder tools in xrmtoolbox, it can provide data type and dropdown list for available actions so you can construct updateMultiple request properly.

https://www.xrmtoolbox.com/plugins/GuidoPreite.DRB/

to use this tool, first download and run xrmtoolbox, its a free community open source tool


then find REST builder tool in the tool library and run it. connect to your environment and start using it.

[parvezghumra]

@mhaupt Have you been able to successfully test your request using Postman/Dataverse Rest Builder or similar? Do you get a 2xx response? If not, are you able to obtain a more detailed error which might give some clues for troubleshooting?

[mhaupt]

I 've run the query:
.getGlobalContext().getClientUrl() + "/api/data/v9.2/mh_glaccounts.UpdateMultiple"
in the REST builder (ta) and got the following:
""Resource not found for the segment 'mh_glaccounts.UpdateMultiple'."

However this URL is similar structure to in the Microsoft article here.

[a33ik]

Have you tried to use

.getGlobalContext().getClientUrl() + "/api/data/v9.2/mh_glaccounts/Microsoft.Dynamics.CRM.UpdateMultiple"?

[mhaupt]

Hi a33ik, I did and got this message about invalid URL structure.  Guess I need to find someone who has implemented this in python

"The request URI is not valid. Since the segment 'mh_glaccounts' refers to a collection, this must be the last segment in the request URI or it must be followed by an function or action that can be bound to it otherwise all intermediate segments must refer to a single resource."

[mhaupt · Accepted solution]

Solved it!  Thanks for everyone's advice on analysing with Postman etc.  Once I got the URL sorted, took me a while to work out what the @OData.type should be:  it's the entity name, but singular (no trailing s)

[TomLai]

I dont see UpdateMultiple on 

Dataverse REST Builder 1.0.0.44

Could you show me how to get that please? ty