Unanswered

Struggling to use Updatemultiple to update dataverse table

(0) Share

Report

Posted on by 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 😞

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

steeevid 323 Super User 2024 Season 1 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (1)

Report

@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?

Was this reply helpful? Yes No
mhaupt 87 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (1)

Report

Have you tried to use

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

Was this reply helpful? Yes No
mhaupt 87 on at

Like (0)

Report

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."

Was this reply helpful? Yes No
Verified answer

mhaupt 87 on at

Like (2)

Report

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)

Was this reply helpful? Yes No
TomLai 8 on at

Like (0)

Report

I dont see UpdateMultiple on
Dataverse REST Builder 1.0.0.44

Could you show me how to get that please? ty

Was this reply helpful? Yes No