Popular posts

Glad to hear this was helpful! I haven’t encountered this issue, and the flow continues to run without errors on my end. I’d recommend double-checking your steps, ensuring the API request details. If you can share the exact error details, that might help in troubleshooting further.

The step that gives the error is the Invoke an HTTP request. As far as I can tell my configuration is correct. I have provided the raw input and output below in case this helps at all. +++++++++ RAW INPUT: +++++++++ { "host": { "connectionReferenceName": "shared_webcontents", "operationId": "InvokeHttp" }, "parameters": { "request/method": "POST", "request/url": "/api/data/v9.0/ExportToExcel", "request/body": "{\n \"View\": {\n \"@odata.type\": \"Microsoft.Dynamics.CRM.savedquery\",\n \"savedqueryid\": \"00000000-0000-0000-00aa-000010001004\"\n },\n \"FetchXml\": \"\",\n \"LayoutXml\": \"\",\n \"QueryApi\": \"\",\n \"QueryParameters\": {\n \"Arguments\": {\n \"Count\": 0,\n \"IsReadOnly\": true,\n \"Keys\": [],\n \"Values\": []\n }\n }\n}" } }

++++++++++++ RAW OUTPUT: ++++++++++++ { "statusCode": 302, "headers": { "Cache-Control": "no-cache", "Location": "/_common/error/err.aspx?BackUri=&ErrorCode=&Parm0=%0d%0a%0d%0aError%20Details%3a%20An%20unhandled%20exception%20occurred%20during%20the%20execution%20of%20the%20current%20web%20request.%20Please%20review%20the%20stack%20trace%20for%20more%20information%20about%20the%20error%20and%20where%20it%20originated%20in%20the%20code.&RequestUri=%2fmain.aspx%3fappid%3db7aa3e9c-05be-ed11-83ff-000d3a9cb073%2fmain.aspx%3fappid%3db7aa3e9c-05be-ed11-83ff-000d3a9cb073%2fapi%2fdata%2fv9.0%2fExportToExcel&user_lcid=1033", "Set-Cookie": "ARRAffinity=62d75af3a8bd70def6443e91bb89612777b69b638e2648807f65870c233313c2dc748ed02332839cb0efbb9e2898da096c2226348c1e154ec1706e5f470d25ad08DD6BD28EFF03730000001652034368; path=/; secure; HttpOnly,ReqClientId=92871977-53a8-4772-b17e-aa24bea04cd4; expires=Mon, 25-Mar-2075 18:53:44 GMT; path=/; secure; HttpOnly,orgId=61170561-607c-4729-a451-590c5eadf4d7; expires=Mon, 25-Mar-2075 18:53:44 GMT; path=/; secure; HttpOnly,MSCRM_LastServiceRequestId=ab80f01c-eb0b-4a47-822f-5c5bf959dd03; expires=Tue, 25-Mar-2025 19:53:44 GMT; path=/; secure; HttpOnly,ARRAffinity=62d75af3a8bd70def6443e91bb89612777b69b638e2648807f65870c233313c2dc748ed02332839cb0efbb9e2898da096c2226348c1e154ec1706e5f470d25ad08DD6BD28EFF03730000001652034368; path=/; secure; HttpOnly", "x-ms-service-request-id": "ab80f01c-eb0b-4a47-822f-5c5bf959dd03", "Strict-Transport-Security": "max-age=31536000; includeSubDomains", "REQ_ID": "ab80f01c-eb0b-4a47-822f-5c5bf959dd03", "CRM.ServiceId": "CRMAppPool", "AuthActivityId": "734de636-bc19-4ff7-b43e-662e2c4a0e0a", "x-ms-dop-hint": "64", "x-ms-ratelimit-time-remaining-xrm-requests": "1,199.91", "x-ms-ratelimit-burst-remaining-xrm-requests": "7998", "mise-correlation-id": "5a8c2e0f-6b63-4995-89ed-fc53ba12b941", "X-Content-Type-Options": "nosniff", "X-Source": "112434212082253195439141113650250111698521597751291603796179921753881198241,102137112807417321385135108160601419939253156168207211154732121264251311381824255237", "Public": "OPTIONS,GET,HEAD,POST", "x-ms-client-region": "unitedstates", "x-ms-flavor": "Production", "X-Ms-Workflow-Resourcegroup-Name": "1AF0F5B00A52462AA18A4C263DC310CC-0203C340DACAEF958D769D42569EC617-ENV", "x-ms-workflow-subscription-id": "a2981534-245e-417c-8407-c364e109fa35", "x-ms-environment-id": "0203c340-daca-ef95-8d76-9d42569ec617", "x-ms-tenant-id": "1af0f5b0-0a52-462a-a18a-4c263dc310cc", "x-ms-dlp-re": "-|-", "x-ms-dlp-gu": "-|-", "Timing-Allow-Origin": "*", "x-ms-apihub-cached-response": "true", "x-ms-apihub-obo": "false", "Date": "Tue, 25 Mar 2025 18:53:43 GMT", "Allow": "OPTIONS,GET,HEAD,POST", "Content-Length": "901", "Content-Type": "application/json", "Expires": "-1" }, "body": { "error": { "code": 302, "source": "flow-apim-unitedstates-002-westus-01.azure-apim.net", "clientRequestId": "81e9e213-b18f-4929-97b2-94d5fa29f2c3", "message": "The response is not in a JSON format.", "innerError": "Object moved\r\n

Object moved to here.

\r\n\r\n" }

James Vergis I was unable to identify the issue, as the error message is too generic to determine the exact cause. I recommend testing the same query in Postman or another tool to gain more insights.