API and Web Data Connector

[knozawa]

Here is my Text Input data

url	api_key	start_date	end_date	id
https://api.xxxxx?auth=xxxxx&start=xxxxx&end=xxxxx&id=xxxxx	xxxxx	xxxxx	xxxxx	xxxxx

I used interface tools to replace value in Tableau Web Data Connector.  However, the url contains api_key, start_date, end_date, and id, so I always get the same result.

Does anyone know how to approach this?

Thank you,

Kazumi

[KaneG]

Hi @knozawa,

You need to use a formula tool after the text input to construct the URL from the fields that you have changed.

Kane

[knozawa]

Hi KaneG,

Thank you for your reply.

I used a formula tool after the text input. However, I still have an error message "Type mismatch in operator +".

My formula is like this:

[url] = "https://api.xxxxxxxxxxxxxxxxxxxx?auth="+[api_key]+"&start="+[start_date]+"&end="+[end_date]+"&id="+[...

Would you know how to approach this issue?

Thank you,

Kazumi

[knozawa · Accepted solution]

[id] was int64, so I changed formula to following:

"https://api.xxxxxxxxxxxxx?auth"+[api_key]+"&start="+[start_date]+"&end="+[end_date]+"&id="+ToString(...])

It works now!

Thank you.

Kazumi

[awojciechowski]

could you save here or share me file with this Alteeryx function because I'm looking solutions to change automatically start dade and end date in a few URL in the same time. 

[awojciechowski]

could you share me workflow in alteryx to change this part of URL.

I have really basic knowledge so I need more your help

[KaneG]

Hi @awojciechowski,

Here is an example of dynamically changing those dates in the address:

The text input holds the 4 variables that are included in the api address. The formula tool constructs the address according to these variables with the following formula:

"https://api.xxxxxxxxxxxxx?auth"+[api_key]+"&start="+[start_date]+"&end="+[end_date]+"&id="+ToString(...])

[awojciechowski]

Thanks for help, It works very good :)