API Header creation

[Deano478]

Hi all,

This is a slightly random question but here it goes. I'm working currently on sending requests to certain APO via Alteryx and there is 1 question/issue I need insights/assistance on.

When I run my request to get a bearer token which works perfectly btw the token due to its length get truncated so when I try and create an Auth Header like so in a formula: 'Bearer '  + [Token] it will take the truncated value and hence my follow on request is unauthorised. So i have had to resort to running the request for a token manually in postman and copying the value into Alteryx which is pain staking so is there a way around this?

Cheers for any  insights as this truncation issue is nothing but a pain in every possible way

[aatalai]

@Deano478 you could try saving it to a file (yxdb) and then try reading that file in later (hopefully it will not be truncated then,

please let me know how you get on 

[abacon]

@Deano478 This could be a datatype issue, throw a select after the bearer is generated and look at the length. If need be you can increase it so nothing gets cut off. That is most likely the issue as I have made many API calls and that is the only limitation I can think of here.

Bacon

[apathetichell]

throw a select tool before your formula. increase the size of the field. this is just a field size issue. you should be using  vw_string with a larger size.

[abacon]

@apathetichell Thank you, I realize I didn't detail how to do it.

[apathetichell]

Yup... I am 100% sure that it is not an issue that the JWT token is larger than the max vw_string setting. Max size of an HTTP header in apache is 8K --- ie your JWT cannot be more than say 7990 characters.