Precog Universal API Connector
Precog’s Universal API Connector provides a fast, simple, No Code approach for configuring analytic ready access to any REST or SOAP API.
Variables
User-defined Variables can be used anywhere in the connector configuration. We recommend defining a Variable for any value you’ll need to use more than once.
Throttling
Authentication
Precog supports authentication via Basic Authentication, OAuth 2.0, and Request Token Authentication. In this example, we consider the OAuth 2.0 authentication flow.
Enter the Authorization Endpoint and Token Endpoint , as specified by the API documentation. Then enter your Client Id and Client Secret , which are generally provided when you create a new application in the API’s developer portal.
Then enter any additional Scopes and Authorization Parameters, as required per the API documentation. Select the Client Authentication Method that will be used during the authentication flow.
Authentication
Datasets – Parent Datasets
Next, we configure the datasets. In this example, each dataset connects to an Asana API endpoint.
Here we create the Projects dataset, which provides data about all the Asana Projects available.
Now that we have access to all the Asana Projects, we’d like to gather information about each of the Projects individually. To achieve this, we can use the Projects dataset as a Parent Dataset for a subsequent API request.
Here we see that the Project dataset is configured with the Projects dataset as its Parent Dataset. This configuration specifies that each Project Id value (which Asana calls a gid) will be passed individually into the endpoint:
https://app.asana.com/api/1.0/projects/{{precog_dac4c027-b3bf-4550-81a4-8764256563ec}}
in place of the variable {{precog_dac4c027-b3bf-4550-81a4-8764256563ec}}. This will produce one dataset that contains the detailed information about all the Asana projects.
Datasets – Pagination
API endpoints often return results spread across multiple pages. To support these APIs, Precog supports various kinds of pagination. In particular, Precog supports: Token Pagination , Offset Pagination , and Header Pagination, each of which include various configurations of their own.
Here we see the Offset Pagination configuration for Precog’s MailChimp connector. Precog will automatically make one request per page until there are no more pages available.
Summary
Once a new connector is configured Precog will automatically create tables from the source data.
The “magic” of Precog is you don’t need to do any manual mapping or parsing of the API data, simply pick from the list of tables presented in the Precog UI and start using it with your favorite tool.
Precog can manage all your tables and load them on a schedule from every 30 seconds to once per day and everything in between, or you can choose to load them anytime by simply choosing “Load All” from the menu. When you load the data Precog will automatically fetch the most recently updated data from the API.
Now anyone can access any API and get analytic ready tables in minutes.
Ready to Start?
FROM OUR CUSTOMERS