Answered

Connecting to Success Factors

(3) Share

Report

Posted on by Nikhil2

522

I would like to build a power automate cloud flows where I can be able to fetch the data using OAuth out of success factors (SAP) and load them to excel worksheet via PA cloud flows, since this is new to me. I would be looking for some ref here.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@Nikhil2 Hi,

Hope those article help you a little bit.

SAP Integration for the Power Platform

SAP connector

good luck.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@stampcoin Hello,

According to my req, the links are out of scope. Success Factors is cloud platform and the link is ref to On Prem. Not sure if that can support in my case. I would like to know is there any direct way of connecting to SAP cloud platforms ?

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@Nikhil2 Hi,

You might consider buliding your own connector, or just use http request within powerautomate ( need app resigter in Azure AD first).

reference article:

https://blog.bajonczak.com/fetching-data-from-sap-successfactors-via-odata-and-oauth/?

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@stampcoin Is it possible to share a sample flow ? Thank you for your effort in advance.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

Nikhil2 Hi,

I don't have any SAP product.

I can share how to invoke Dynamic 365 (Online) via powerautomate. see below pic, hope that give you some idea.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@stampcoin Thank you for the effort, Is there any possibility to share the other connectors by expanding them. And I wanted to know is this best way to fetch 10k records ?

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@Nikhil2 Hi,

Sure,

Some article you may need for authentication:

Custom Connector

Register an application in Microsoft Entra ID

The Schema you can use the HTTP output data for generating it, See the bottom marked

Below is Initialize the target url. It's for the rest steps to use.

Then the URI step : I don't want to interact with account logon, So I Bearer the token here.

You can add more query parameters here.

I specify one table for testing.

Put everything together.

it's just a draft flow, it tells the structure.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@stampcoin Quick question, Do you think below way would be fastest way to pull the 10k data faster ? Thank you for the example.

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@Nikhil2， Hi,

It depends on your data volume. you can start from 1000, 2000, 5000. in crease the volume step by step.

if you don't consume the data for others like in power apps. dataverse, etc.

you don't need power automate.

you can use this in python, powershell, c# whatever you like. the example is generic HTTP request.

1 people found this reply helpful.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@stampcoin I was try to process the body client id and client with oauth token in URI but it returns forbidden. What is wrong here?

Was this reply helpful? Yes No