Tableau connection
[vc_row row_type=”row” type=”grid” anchor=”products” text_align=”left” border_color=”#eaeaea” padding_top=”51″ padding_bottom=”0″ css_animation=””][vc_column][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner]
Tableau is a popular software company whose work is focused on business intelligence. It allows you to get a better understanding of your data and connect to any database.
One such database can be competitor pricing data – originating from your Price2Spy account.
Since more and more Price2Spy clients want to connect their Tableau via Price2Spy API, we decided to share this mini-guide with you.
Connecting Tableau to Price2Spy API
To connect your Tableau with Price2Spy API you need to follow these steps (click on the image to get it enlarged):
1. Once in Tableau software click on more. Then click on Web Data Connector (see screenshots 1 and 2)
3. Click on Generic REST API (see screenshot 4)
4. Simple GET operation
- Insert appropriate endpoint. In this example https://api.price2spy.com/rest/v1/get-brands
- Select GET method
- Add a new custom header with
- Name = Authorization
- Value = Basic base64 encoded API key
- Click on “Make request” (see screenshot 5)
If you need a specific path, fill in Path to export. If not leave blank and click “Load into Tableau” button (see screenshot 6)
5. POST operation
- Insert appropriate endpoint. In this example https://api.price2spy.com/rest/v1/get-current-pricing-data
- Select POST method
- Add a new custom header with
- Name = Authorization
- Value = Basic base64 encoded API key
- Body Type = RAW
- Raw Body = filter by any parameter supported in this case body = {“brandName”:”Arturia”}
- Click on “Make request” (see screenshot 7)
If you need a specific path, fill in Path to export. If not leave blank and click “Load into Tableau” button (see screenshot 8)
For any questions you might have, please feel free to contact us at support@price2spy.com – we would be happy to help you.
In case you are new to Price2Spy, you are welcome to start your free 30-day trial to establish a Tableau connection via Price2Spy API, (using any kind of API method you need).