Connect Rewardata to Microsoft Power Platform

1. Download the connector definition: rewardata-power-automate.swagger.json.
2. In Power Automate (or Power Apps), go to Data → Custom connectors → New custom connector → Import an OpenAPI file, and upload the file.
3. Review — host api.rewardata.com, security API Key (X-API-Key) — then Create connector.
4. Create a connection: paste your rwd_… API key when prompted. Done — the actions are now available in any flow/app.

With the connector

1. Add a step → search Rewardata → pick QueryData.
2. Fill in country (e.g. DEU), field (e.g. living_wage_net_monthly), year.
3. Use the returned value in later steps (Excel, SharePoint, Teams, email).

Without a connector (HTTP action)

Method:  GET
URI:     https://api.rewardata.com/api/v1/data?country=DEU&field=living_wage_net_monthly
Headers: X-API-Key: rwd_your_key

Surface live country data inside a canvas app — e.g. a relocation calculator.

1. In your app, Data → Add data → Connectors → choose your Rewardata custom connector.
2. Call an action from a control. Example formula on a button/label:

// returns the rows for the chosen country/field
ClearCollect(
    rewards,
    Rewardata.QueryData({country: cmbCountry.Selected.Value,
                         field: "average_monthly_earnings"}).value
)

For server-side / IT-owned integrations. Two options:

1. HTTP action — add an HTTP action with method GET, the URL above, and an X-API-Key header. No connector needed.
2. OpenAPI import — Logic Apps can consume our spec directly: api.rewardata.com/openapi.json (or the downloaded Swagger).

Bulk: one call for many rows

POST https://api.rewardata.com/api/v1/bulk-query
X-API-Key: rwd_your_key
Content-Type: application/json

{ "queries": [
    {"country":"USA","field":"income_tax_rate_at_average_wage","year":2025},
    {"country":"FRA","field":"income_tax_rate_at_average_wage","year":2025}
] }

Let a Copilot answer reward questions in natural language. Two routes:

1. Connector action — add the Rewardata custom connector as a tool/action in your Copilot, so it can call QueryData.
2. MCP endpoint — connect our hosted server https://www.rewardata.com/mcp (OAuth sign-in). The Copilot then has six tools (query_hr_data, compare_countries, list_fields…) and can answer e.g. "compare the minimum wage in Poland, Spain and Portugal."

CLI clients use the same endpoint with a header: Authorization: Bearer rwd_your_key. See the MCP section.

1. Create a GPT — in ChatGPT, open Explore GPTs → Create, then the Configure tab.
2. Add an Action — under Actions → Create new action, in the Schema box click Import from URL and paste
   https://rewardata.com/static/connectors/rewardata-openai-actions.json
   (or download it below and paste the JSON directly).
3. Authentication — choose API Key, Auth Type: Custom, Header name X-API-Key, and paste your rwd_… key.
4. Save & test — ask e.g. "What's the statutory minimum wage in Germany, and how does it compare to France and Spain?"

Paste this into the GPT's Instructions

You are a Total Rewards assistant with live access to the
Rewardata API (pay, tax, social security, cost of living,
living wage, hours, leave, pensions and FX for 200+ countries).

- To find exact codes, call listCountries, listCategories
  and listFields before querying.
- Use queryData for one value (country + field [+ year]);
  use bulkQuery to compare many countries/fields at once.
- For currency conversion, call fxRate.
- Always report the value with its unit, year and source.
- Never invent numbers. If the API returns nothing, say so.