I am creating a report from Survey123, which I then would like to upload directly to basecamp 3, but keep getting the following error:
Error: Action ‘Upload_file’ failed
The message body is not a valid JSON. Error reading JObject from JsonReader. Path '', line 0, position 0.
at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader, JsonLoadSettings settings)
at Gateway.Pipeline.IO.JObjectFormatter.Format(JsonTextReader jsonTextReader)
at Gateway.Pipeline.IO.JsonConverter.Convert[T](Stream stream, Encoding encoding, ILog log, Object conversionSettings)
at Microsoft.WindowsAzure.ApiManagement.Proxy.Gateway.MessageBody.As[T](Boolean preserveContent)
Survey123 gives you a url with the report, so I tried uploading file to One Drive with URL, which worked, and then uploading to basecamp from there with no luck. I also did HTTP GET on the report and used the body from that as the file content with no luck, but that did allow me to attach it to an email, so I know the content is there.
Lastly, I tried putting the flow into a solution and pulling the file content from the One Drive document, but that also failed.
Any help would be appreciated. I don't have screenshots of the other attempts I made, but I'm sure I can recreate them if that would be helpful.

Report
All responses (
Answers (