ApiSkills

Power Automate

Two ways in: a ready-made Custom Connector (recommended), or the raw HTTP action. Flows can't be shared as reliable importable files, so these are step-by-step recipes — plus the connector spec you can import directly.

Before you start — the honest caveats

  • The HTTP action and custom connectors are premium Power Automate features (licensing cost).
  • Signature auth (HMAC, Digest, OAuth 1.0a) isn't practical here — those need custom code.
  • Pagination isn't automatic with the HTTP action (our next link isn't OData) — use a Do Until loop, or the custom connector which auto-paginates.
  • Group-by, pivot, and running totals are weak natively — do those in Power Query/Excel and use Power Automate for orchestration.

1. Custom Connector (recommended)

Import our OpenAPI spec once and get typed, drag-and-drop actions with the API key handled for you. The same connector works in Power Automate and Power Apps.

  1. Power Automate → Data → Custom connectors → New → Import an OpenAPI from URL.
  2. Paste this URL: https://api.ifsjaipur.cloud/openapi.json
  3. On the Security step, it uses API Key (x-api-key) — paste your app's API key when you create the connection.
  4. Create → use the GetData action (auto-paginates via nextLink).

2. Auth with the HTTP action

API key (header)

HTTP action → Headers → add x-api-key : YOUR_API_KEY. URL: https://api.ifsjaipur.cloud/playground/data/stocks/candles?shape=flat&page_size=50.

Basic

HTTP action → Authentication = Basic → Username = App ID, Password = App Secret.

Bearer

HTTP action → Headers → Authorization : Bearer YOUR_TOKEN.

OAuth2 client credentials (2 steps)

HTTP action 1 → POST https://api.ifsjaipur.cloud/oauth/token, body application/x-www-form-urlencoded: grant_type=client_credentials&client_id=APP_ID&client_secret=APP_SECRET&scope=stocks:read. Then Parse JSON → use access_token as a Bearer header in HTTP action 2.

3. Pagination (Do Until loop)

  1. Initialize a string variable NextUrl = https://api.ifsjaipur.cloud/playground/data/stocks/candles?shape=flat&paginate=cursor&page_size=50.
  2. Initialize an array variable Rows = [].
  3. Do Until NextUrl is empty: HTTP GET NextUrl → Parse JSON → Append to Rows = body/data → Set NextUrl = body/nextLink (empty when done).

The custom connector does this for you via x-ms-pageable — the Do Until is only for the raw HTTP action.

4. Data operations

Reshape / pick columns

Select action → map each item to a smaller object (e.g. keep ticker, date, close).

Filter rows

Filter array action → keep items where e.g. volume > 2000000.

Compute a field

Select with an expression, e.g. change % = div(sub(item()?['close'], item()?['open']), item()?['open']).

Group-by / pivot / running total

Not native. Send the rows to Excel (Office Scripts) or use Power Query for these.