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
@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
@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
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.
@apathetichell Thank you, I realize I didn't detail how to do it.
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.