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¶
- Get Data → OData feed, paste the URL.
- Authentication: Basic, user name apikey, password your API key.
-
Pick the datasets in the navigator. Filter on the date column for incremental refresh: only those days are read.
-
Incremental refresh: filter the date column on RangeStart and RangeEnd; Power BI sends the range and only those days are read.
- Refreshes in the Power BI service without a gateway (Basic authentication on an OData feed).
Excel¶
- Data → Get Data → From Other Sources → From OData Feed, paste the URL.
-
Authentication: Basic, user name apikey, password your API key.
-
Same Power Query as Power BI: a date filter is sent to InfoTrie too.
Tableau¶
- Connect → To a Server → OData, paste one dataset's URL.
- Authentication: Username and Password, user name apikey, password your API key.
-
Tableau reads OData as an extract.
-
Every extract refresh reads the whole dataset: keep large datasets to Power BI's incremental refresh or Qlik with a date range.
Qlik Sense¶
- Create new connection → REST, paste one dataset's URL; add from= and to= for a date range.
- Query headers: X-API-Key = your API key.
-
Pagination: Next URL, path root/next. Select data: root/data.
-
Add from= and to= (yyyy-mm-dd) to the URL for an incremental load.
Google Sheets¶
- In the spreadsheet: Extensions → Apps Script. Paste Code.gs; in Project Settings, show the manifest and paste appsscript.json. Save, then reload the spreadsheet.
- InfoTrie → Set API key…: the key is kept in your own Google account, never in the spreadsheet.
- 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¶
- At script.google.com: New project. Paste Code.gs and, in Project Settings, the manifest appsscript.json.
- Deploy → Test deployments → Looker Studio: open the link to add InfoTrie as a data source.
- 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).