Tableau connection

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.

[vc_empty_space][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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)

 

 

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshots 1 and 2[/vc_column_text][vc_single_image image=”126140″ img_size=”full” add_caption=”yes” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_single_image image=”126149″ img_size=”full” add_caption=”yes” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_empty_space][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

2.  In URL bar insert https://rdc.codezero.xyz/#/ and press “enter” (see screenshot 3)

 

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 3[/vc_column_text][vc_single_image image=”126158″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

3. Click on Generic REST API (see screenshot 4)

 

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshot 4[/vc_column_text][vc_single_image image=”126167″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/6″]

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)

 

[/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshots 5 and 6[/vc_column_text][vc_single_image image=”126176″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_single_image image=”126185″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_empty_space][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner width=”4/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)

 

 

[vc_empty_space height=”64px”][/vc_column_inner][vc_column_inner width=”2/6″][vc_column_text]Screenshots 7 and 8[/vc_column_text][vc_single_image image=”126194″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][vc_single_image image=”126203″ img_size=”full” alignment=”center” onclick=”img_link_large” qode_css_animation=””][/vc_column_inner][/vc_row_inner][vc_empty_space height=”64px”][vc_row_inner row_type=”row” type=”grid” text_align=”left” css_animation=””][vc_column_inner]

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).

 

[vc_empty_space][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]