Search posts, tags, users, and pages
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?
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
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.