Forum Discussion
Invalid Auth Header from Web Activity for SalesForce
Hello and thank you for your reply. While working this request through Postman I received additional information the object I am intending to query may not be supported in a client credentials auth flow. I am checking with SalesForce support on what items I need to enable to support query base objects using client credentials.
Hi kxwillis ,
Thanks for the reply. Do let me know incase of further queries with Fabric.
- Anonymous2 years agoNot applicable
Hi kxwillis ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .- kxwillis2 years agoRegular Visitor
The permissions issue in SalesForce was resolved and verified yesterday, so the process works in Postman now. However, I am still receiving the INVALID_AUTH_HEADER response when implementing inside of the web activity in Fabric. See the below...
WEB ACTIVITY INPUT{"method": "POST","headers": {"Authorization": "Bearer [token]","Content-Type": "application/json","Accept": "application/json"},"relativeUrl": "/services/data/v51.0/jobs/query","body": {"operation": "query","query": "SELECT Id FROM Account WHERE RecordType.Name <> 'Provider Account'"}}WEB ACTIVITY OUTPUT{"Response": "[{\"message\":\"INVALID_AUTH_HEADER\",\"errorCode\":\"INVALID_AUTH_HEADER\"}]","ResponseHeaders": {"Date": "Fri, 24 May 2024 12:58:08 GMT","Set-Cookie": "CookieConsentPolicy=0:1; path=/; expires=Sat, 24-May-2025 12:58:08 GMT; Max-Age=31536000; secure;LSKey-c$CookieConsentPolicy=0:1; path=/; expires=Sat, 24-May-2025 12:58:08 GMT; Max-Age=31536000; secure;BrowserId=ROBfwxnNEe-4RlOJI9bR_g; domain=.salesforce.com; path=/; expires=Sat, 24-May-2025 12:58:08 GMT; Max-Age=31536000","Strict-Transport-Security": "max-age=63072000; includeSubDomains","X-Content-Type-Options": "nosniff","X-Robots-Tag": "none","Cache-Control": "no-store, must-revalidate, no-cache, max-age=0, private","WWW-Authenticate": "Token","Transfer-Encoding": "chunked","Content-Type": "application/json; charset=UTF-8"},"executionDuration": 0}- Anonymous2 years agoNot applicable
Hi kxwillis ,
I would like to understand how are you sending Bearer token in Fabric Web Activity?
Can you please refer the below similar threads -
Ingest data form a rest API with Oauth2 - Microsoft Fabric Community
Solved: retrieve token api call with content type x-www-fo... - Microsoft Fabric Community
Hope this is helpful. Do let me know incase of further queries.