Skip to content

BI connectors

The datasets of your plan in Power BI, Excel, Tableau, Qlik, Google Sheets and Looker Studio, without code.

One feed serves every dataset your plan covers: an OData v4 service at https://api.infotrie.com/api/bi/v1/odata, which Power BI, Excel and Tableau open with their built-in connector, and pages of JSON or CSV under https://api.infotrie.com/api/bi/v1/datasets for the others. Use an API key from the dashboard. Tools that ask for a user name and a password take any user name (apikey) and the key as password; the others send it as the X-API-Key header. Your dataset list, with each one's URLs, is on Datasets.

Rows read count against your monthly quota: one unit per 100 rows. Filter on the date column to read only the days you need. Price, index and calendar history is paged by date, so a full refresh reads in one pass. On other datasets, past 1,000,000 rows in one range the feed asks for a shorter range rather than stopping silently, so a refresh never keeps part of the data as if it were all of it.

For a value or a short table in a cell, such as a company's sentiment today, the Excel add-in adds INFOTRIE functions to Excel.

Power BI

https://api.infotrie.com/api/bi/v1/odata
  1. Get Data → OData feed, paste the URL.
  2. Authentication: Basic, user name apikey, password your API key.
  3. Pick the datasets in the navigator. Filter on the date column for incremental refresh: only those days are read.

  4. Incremental refresh: filter the date column on RangeStart and RangeEnd; Power BI sends the range and only those days are read.

  5. Refreshes in the Power BI service without a gateway (Basic authentication on an OData feed).

Excel

https://api.infotrie.com/api/bi/v1/odata
  1. Data → Get Data → From Other Sources → From OData Feed, paste the URL.
  2. Authentication: Basic, user name apikey, password your API key.

  3. Same Power Query as Power BI: a date filter is sent to InfoTrie too.

Tableau

https://api.infotrie.com/api/bi/v1/odata/{dataset}
  1. Connect → To a Server → OData, paste one dataset's URL.
  2. Authentication: Username and Password, user name apikey, password your API key.
  3. Tableau reads OData as an extract.

  4. Every extract refresh reads the whole dataset: keep large datasets to Power BI's incremental refresh or Qlik with a date range.

Qlik Sense

https://api.infotrie.com/api/bi/v1/datasets/{dataset}/rows?format=json&limit=10000
  1. Create new connection → REST, paste one dataset's URL; add from= and to= for a date range.
  2. Query headers: X-API-Key = your API key.
  3. Pagination: Next URL, path root/next. Select data: root/data.

  4. Add from= and to= (yyyy-mm-dd) to the URL for an incremental load.

Google Sheets

https://api.infotrie.com/api/bi/v1/datasets/{dataset}/rows
  1. In the spreadsheet: Extensions → Apps Script. Paste Code.gs; in Project Settings, show the manifest and paste appsscript.json. Save, then reload the spreadsheet.
  2. InfoTrie → Set API key…: the key is kept in your own Google account, never in the spreadsheet.
  3. InfoTrie → Import a dataset…, with a date range; Refresh all imports reads them again.

Download: Code.gs · appsscript.json

  • Up to 200,000 rows per sheet; past them the import says it stopped.

Looker Studio

https://api.infotrie.com/api/bi/v1/datasets/{dataset}/rows
  1. At script.google.com: New project. Paste Code.gs and, in Project Settings, the manifest appsscript.json.
  2. Deploy → Test deployments → Looker Studio: open the link to add InfoTrie as a data source.
  3. Give your API key, then pick one dataset. The report's date range is sent to InfoTrie: a report reads only the days it shows.

Download: Code.gs · appsscript.json

  • Up to 100,000 rows per chart request; past them the chart asks for a shorter range.

Every parameter and response is in the API reference (tag BI feed).