Do you want to access REST API data from Tableau for analytics or data visualization? It can be tricky, as connecting to any REST API usually requires investing time and custom programming to get it right. Fortunately, with Progress DataDirect Autonomous REST Connector, you can instantly connect to any REST API without any code and query your REST API using SQL 92.
Autonomous REST Connector uses intelligent sampling to normalize the JSON responses from REST API and make them available as relational tables. You are empowered to use the full capabilities of SQL, including joining data from different endpoints.
To get you started on how you can use the Autonomous REST Connector with Tableau, in this article we will walk you through on how you can connect to HubSpot API. HubSpot is a popular marketing automation and CRM platform for marketing, sales, and customer service. This will give you an overview of how flexible Autonomous REST Connector is and how it works. Let’s get started.
curl https:
//api.hubapi.com/contacts/v1/lists/all/contacts/all?hapikey=456****cfa
{
"Companies"
:
"https://api.hubapi.com/companies/v2/companies/paged"
,
"CompanyProperties"
:
"https://api.hubapi.com/properties/v1/companies/properties"
,
"ContactsLists"
:
"https://api.hubapi.com/contacts/v1/lists"
,
"ContactProperties"
:
"https://api.hubapi.com/properties/v1/contacts/properties"
,
"Deals"
:
"https://api.hubapi.com/deals/v1/deal/paged"
,
"DealProperties"
:
"https://api.hubapi.com/properties/v1/deals/properties"
,
"DealPipelines"
:
"https://api.hubapi.com/deals/v1/pipelines"
,
"Engagement"
:
"https://api.hubapi.com/engagements/v1/engagements/paged"
,
"Forms"
:
"https://api.hubapi.com/forms/v2/forms"
,
"Owners"
:
"https://api.hubapi.com/owners/v2/owners"
,
}
Feel free to download and try Progress DataDirect Autonomous REST Connector to connect to any REST API from Tableau. If you have any questions, feel free to talk to us.