Send HTTP Request template problem

(0) Share

Report

Posted on by ernu

140

Hello all,

When I try to send http request to SharePoint list, I get an error like below. How can I solve this problem? Where do I need to start?

You can see details of my http request block:

Uri:

_api/web/lists/getbyTitle('MyList')/items(@{first(outputs('Get_items')?['body/value'])['ID']})/validateUpdateListItem

Body:

{
 "formValues":[
 {
 "FieldName": "Status",
 "FieldName": "Approved"
 }
 ],
 "bNewDocumentUpdate": true
}

Thanks in advance,

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Could you show the output of "Get Items"?

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can see the details of my Get Items step in the below. All inputs are string.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

I've asked for output of "Get Items".

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!
Ups, sorry. Here it is

{ "statusCode": 200, "headers": { "Transfer-Encoding": "chunked", "Vary": "Origin,Accept-Encoding", "X-NetworkStatistics": "0,1051136,82,174,213099,0,1051136", "X-SharePointHealthScore": "3", "X-MS-SPConnector": "1", "X-SP-SERVERSTATE": "ReadOnly=0", "DATASERVICEVERSION": "3.0", "SPClientServiceRequestDuration": "45", "X-DataBoundary": "EU", "X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/", "X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0", "SPRequestGuid": "09e5e6bd-71d0-46bb-bcf6-5a844297ffc5", "request-id": "09e5e6bd-71d0-46bb-bcf6-5a844297ffc5", "MS-CV": "veblCdBxu0a89lqEQpf/xQ.0", "Strict-Transport-Security": "max-age=31536000", "X-FRAME-OPTIONS": "SAMEORIGIN", "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;", "MicrosoftSharePointTeamServices": "16.0.0.23422", "X-Content-Type-Options": "nosniff", "X-MS-InvokeApp": "1; RequireReadOnly", "Timing-Allow-Origin": "*", "x-ms-apihub-cached-response": "false", "x-ms-apihub-obo": "false", "Cache-Control": "max-age=0, private", "Date": "Thu, 09 Mar 2023 11:51:15 GMT", "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Type": "application/json; charset=utf-8", "Expires": "Wed, 22 Feb 2023 11:51:15 GMT", "Last-Modified": "Thu, 09 Mar 2023 11:51:15 GMT", "Content-Length": "12" }, "body": { "value": [] } }

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

As you can see it returns an empty array - check if "value" array is empty before "Send an HTTP request".

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

Why can be returns empty array?
For example, when I triggered the flow and check the result of "Get Item", I can see the values in Filter Query section. Why does the empty array come up though?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

At first - why you are using the "Get items" but not the "Get item" action? As far as I know you want to update a single item, correct?

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

Yes, you're right. But I need to filter rows before update. That's why, I used filter query in the "Get Items".
When I check the "Get Item", I couldn't see any filter. There is just ID as input. I don't know, how can I manage this.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

But filtering can return nothing, correct? You have to handle the empty array then.

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!
Actually, no. I can see the values in the return of filtering. Yes, I need to handle the empty array.

(Approver eq 'Jack Wilson') and (Project eq 'Air Flow') and (Status eq 'Rejected')

Was this reply helpful? Yes No