cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Update D365CE record throws "HTTP Error 400. The request URL is invalid."

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".Anmerkung 2019-06-04 090540.pngAnmerkung 2019-06-04 090631.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

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

tete.png

Hope this Helps!

View solution in original post

11 REPLIES 11
Highlighted
Dual Super User III
Dual Super User III

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

 

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!

Highlighted
Frequent Visitor

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

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

Highlighted
Dual Super User III
Dual Super User III

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

 

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

Highlighted
Frequent Visitor

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

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:

01.png02.png

 

Cheers

Sven

Highlighted
Dual Super User III
Dual Super User III

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

 

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)

Highlighted
Frequent Visitor

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

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:

01.png02.png03.png

 

Sven

Highlighted
Dual Super User III
Dual Super User III

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

HI @Sven_Burkhardt 

 

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!

Highlighted
Frequent Visitor

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

There is no option for the ID:

04.png

Highlighted
Dual Super User III
Dual Super User III

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

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

tete.png

Hope this Helps!

View solution in original post

Highlighted
Frequent Visitor

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

this works. Awesome!

Thanks a lot for your help.

 

Cheers

Sven

Highlighted
Frequent Visitor

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

worked

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (5,276)