Hi,
I have a flow that is using a "Send to HTTP request to SharePoint", the flow basically grabs the contents of list item and then uses this to populate another list. The reason for using the "Sent to HTTP request to SharePoint" action is because the lists have different column names. A couple of the fields that are copied are text and as such they can have punctuation like double/single quotes. When this happens the Flow fails, I assume the quote in the text is being inturupted by JSON as the end of the string. Is there anything I can do to handle punctuation better? Below is the code view of my "Send to HTTP request to SharePoint" action.
{
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['shared_sharepointonline']['connectionId']"
}
},
"method": "post",
"body": {
"method": "POST",
"uri": "/_api/web/lists/getbytitle('Job Card')/items",
"headers": {
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose",
"X-RequestDigest": "form digest value",
"content-length": "length of post body"
},
"body": "{ '__metadata':{ 'type': '@{variables('Type')}' },\n\"Title\": \"@{triggerBody()?['Job_x0020_Summary']}\",\n\"Description_x0020_of_x0020_job\": \"@{triggerBody()?['Job_x0020_Description']}\",\n\"Requestor\": \"@{triggerBody()?['Title']}\",\n\"Request_x0020_Date\": \"@{triggerBody()?['Date']}\",\n\"Hours\": \"@{triggerBody()?['Total_x0020_Hours']}\"\n}"
},
"path": "/datasets/@{encodeURIComponent(encodeURIComponent(triggerBody()?['Customer_x0020_Name_x003a_Custom']?['Value']))}/httprequest",
"authentication": "@parameters('$authentication')"
},
"metadata": {
"flowSystemMetadata": {
"swaggerOperationId": "HttpRequest"
}
}
}Thanks in advance
Rob
