Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Using http connector to get salesforce data in SQL db- getting 401 error

(0) ShareShare
ReportReport
Posted on by 6

Hello everyone,

 

I am trying to build a flow which pulls salesforce Report data using API via http connector , then parsing JSON connector and add them in SQL table.

 

However, if i simply add url and use get method, i am getting invalid session error with status code 404, if i try to add oauth authentication , i am not sure what's supposed to be added in tenant. Can someone please help me. Also, i have added secret and client id from connected app in salesforce, is this accurate 

SophiaDeva_1-1669980962872.png

 

SophiaDeva_0-1669980576323.png

 

  • Nirmal04 Profile Picture
    4 on at
    Re: Using http connector to get salesforce data in SQL db- getting 401 error

    https://powerusers.microsoft.com/t5/Connector-Development/Custom-Connector-Token-Refresh/td-p/194942

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,618 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,957 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow