Solved: Update D365CE record throws "HTTP Error 400. The r...

Anonymous · ‎06-04-2019

Hi everybody,

here is my problem:

I run an reccurance on all appointments inside our CRM instance. I filter all of them in an array to identify all records where "scheduledend" is lessorequal today.

After that I want to update all results and set the status to "completed".

The filter delivers the correct results set of appointments.

I want to accomplish that appointments does not need to get manually marked as completed by the users.

The error-message delivers this body:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"> <HTML><HEAD><TITLE>Bad Request</TITLE> <META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD> <BODY><h2>Bad Request - Invalid URL</h2> <hr><p>HTTP Error 400. The request URL is invalid.</p> </BODY></HTML>

Hope you have an idea on this.

Cheers

Sven

yashag2255 · ‎06-19-2019

Hi @Anonymous

Tap into the identifier field not the apply to each field. You will see options to select from the dynamic selector and from there you can select the Appointment ID.

Please see a sample screenshot below

Hope this Helps!

View solution in original post

yashag2255 · ‎06-04-2019

Hi @Anonymous

Can you confirm if you have enabled access to set the values on those records in that entity?

Also, the environemnt in which you are creating the flow and the environement you are connecting to are those same?

Can you try logging out of the current session close the browser and start a fresh session and then retry again?

Also, you can try using the common data services (CDS) connector to achieve this (If your D365 instance is online and I am assuming it is)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous · ‎06-18-2019

Hi @yashag2255,

thanks for your reply.

I tried to switch to CDS connector but this delivers exactly the same error as using D365 connector.

Logging off and on from the session also does not solve the problem. I even deleted all-time cache from browser to be sure.

I am dealing with Dynamics CRM since 3.0 and wonder, what you mean with "...Can you confirm if you have enabled access to set the values on those records in that entity?..."

The Flow from PowerApps Page (!not Flow-Page from O365!) is created and running under D365-serviceaccount. There should be no limitation concerning access to the CRM.

Cheers

Sven

yashag2255 · ‎06-18-2019

Hi @Anonymous

So after you run the flow, you get the error on which action? Can you please post a screenshot of that?

Anonymous · ‎06-19-2019

Hi @yashag2255,

the error occurs at the final stage where the records should get updated.

The record count is correct.

Here screens of the error from the last stage:

Cheers

Sven

yashag2255 · ‎06-19-2019

Hi @Anonymous

I am guessing that some data type mismatch might be causing this error. Can you please also add a screenshot of the flow of this particular acton where the recors is being updated? I want to see the identifier and the values you are updating. (barring any sensitive information)

Anonymous · ‎06-19-2019

Hi @yashag2255,

here is the oDATA resukts for one record:
{"@odata.id":"https://XXXXXXX.crm4.dynamics.com/api/data/v9.0/appointments(249aa4c6-e485-e911-a836-000d3ab18325)",... inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte\r\n","createdon":"2019-06-03T09:48:47Z","statecode":3,"_statecode_label":"Scheduled","location":"Bei mir am Platz","subject":"Test Termin","_ownerid_value":"486e0273-c944-e911-a822-000d3ab18b39","_ownerid_type":"systemusers","isunsafe":0,"modifiedon":"2019-06-03T09:50:29Z","versionnumber":7039879,"prioritycode":1,"_prioritycode_label":"Normal","isdraft":false,"timezoneruleversionnumber":0,"isregularactivity":true,"isalldayevent":false,"ismapiprivate":false,"_modifiedby_value":"486e0273-c944-e911-a822-000d3ab18b39","_modifiedby_type":"systemusers","outlookownerapptid":-1201444893,"activitytypecode":"appointment","instancetypecode":0,"_instancetypecode_label":"Not Recurring","isworkflowcreated":false,"_createdby_value":"486e0273-c944-e911-a822-000d3ab18b39","_createdby_type":"systemusers","attachmenterrors":0,"_attachmenterrors_label":"None","_owningbusinessunit_value":"3659328c-3327-e911-a991-000d3ab20edc","_owningbusinessunit_type":"businessunits","activityid":"249aa4c6-e485-e911-a836-000d3ab18325","scheduledend":"2019-06-03T11:00:00Z","lastonholdtime":null,"_owningteam_value":null,"exchangeitemid":null,"seriesid":null,"deliverylastattemptedon":null,"_sendermailboxid_value":null,"onholdtime":null,"community":null,"sortdate":null,"_createdonbehalfby_value":null,"_transactioncurrencyid_value":null,"processid":null,"_serviceid_value":null,"_slaid_value":null,"stageid":null,"actualstart":null,"utcconversiontimezonecode":null,"exchangeweblink":null,"senton":null,"_slainvokedid_value":null,"postponeactivityprocessinguntil":null,"_modifiedonbehalfby_value":null,"exchangerate":null,"deliveryprioritycode":null,"actualdurationminutes":null,"traversedpath":null,"activityadditionalparams":null,"leftvoicemail":null,"actualend":null,"subscriptionid":null,"category":null,"originalstartdate":null,"subcategory":null,"importsequencenumber":null,"modifiedfieldsmask":null,"overriddencreatedon":null}

And here are screens from the update-action:

Sven

yashag2255 · ‎06-19-2019

HI @Anonymous

The error is coming in because of the identifier. Yo are using the entire value set over there. Instead, please tap into the identifier and from the dynamic content selector, select the ID of the particular value in the loop.

Hope this Helps!

Anonymous · ‎06-19-2019

Hi @yashag2255,

There is no option for the ID:

yashag2255 · ‎06-19-2019

Hi @Anonymous

Tap into the identifier field not the apply to each field. You will see options to select from the dynamic selector and from there you can select the Appointment ID.

Please see a sample screenshot below

Hope this Helps!