Forum Discussion

kxwillis's avatar
kxwillis
Regular Visitor
2 years ago

Invalid Auth Header from Web Activity for SalesForce

I am issuing a request to a SalesForce bulk API 2.0 from web activity but am receiving an INVALID_AUTH_HEADER resposne and am not sure why.  I do have a valid token from the previous web activity and...
Need Help
pipelines
kxwillis's avatar
kxwillis
Regular Visitor
2 years ago

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
}
  • kxwillis's avatar
    kxwillis
    Regular Visitor
    2 years ago

    I am retreiving the token from the web activity immediately preceeding this step and am passing the token from the output of the preceeding web activity.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi kxwillis 

      Can you please share the screen shot of web activity web1 when you executed the pipeline?
      As the above error says authentication, I would like to understand whether it is passing actual bearer token or not.

      • kxwillis's avatar
        kxwillis
        Regular Visitor
        2 years ago

        Below is the output of web activity 1 and the input of webactivity 2

         

        OUTPUT OF WEB ACTIVITY 1
        {
        "access_token": "00D5Y000001bchT!AQEAQDaYCiIjOZKYySRwnpsY3CloFGzEiTc0abZNK60LiEtqJWnRAvEHwrX363RTqbqwNz.[rest of token]",
        "signature": "[signature]",
        "token_type": "Bearer",
        "issued_at": "1716566138903",
        "ResponseHeaders": {
        "Date": "Fri, 24 May 2024 15:55:38 GMT",
        "Set-Cookie": "CookieConsentPolicy=0:1; path=/; expires=Sat, 24-May-2025 15:55:38 GMT; Max-Age=31536000; secure;LSKey-c$CookieConsentPolicy=0:1; path=/; expires=Sat, 24-May-2025 15:55:38 GMT; Max-Age=31536000; secure;BrowserId=ENrFgBnmEe-_7qNw1875lg; domain=.salesforce.com; path=/; expires=Sat, 24-May-2025 15:55:38 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",
        "Vary": "Accept-Encoding",
        "Transfer-Encoding": "chunked",
        "Expires": "Thu, 01 Jan 1970 00:00:00 GMT",
        "Content-Type": "application/json; charset=UTF-8"
        },
        "executionDuration": 0
        }
         
        INPUT OF WEB ACTIVITY 2
        {
            "method": "POST",
            "headers": {
                "Authorization": "Bearer 00D5Y000001bchT!AQEAQDaYCiIjOZKYySRwnpsY3CloFGzEiTc0abZNK60LiEtqJWnRAvEHwrX363RTqbqwNz.[rest of 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'"
            }
        }
         
        Screenshot of pipeline execution below