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
This is exactly what I have been looking for. However, when I tried to implement it, I get an error with the 'Invoke an HTTP request' action stating that "the response is not in a JSON format." Any idea how to address that?