Forum Discussion
REST API web query fails to refresh when published, integrate retry
Hi MegaOctane1
Check your returned data for something that you know should be there, if it isn't then call the function again. Something like this
. . WebQuery = fxWebFunction(CustomerNumber), CheckQueryResult = if WebQuery[SomeValue] = TRUE then WebQuery else fxWebFunction(CustomerNumber), WebQueryResult = if CheckQueryResult[SomeValue] = TRUE then CheckQueryResult else "Error", . .I obviously don't know what value you need to test for to see of the query succeeded, you'll have to insert that into the code.
There is try..otherwise built into PQ which is meant to catch errors but it doesn't always work as expected (it doesn't trigger on some errors), and it may not work for you anyway in this scenario as the error is from the web server and may not filter through to the PQ code as an actual error condition.
regards
Phil
Hi MegaOctane1
Check your returned data for something that you know should be there, if it isn't then call the function again. Something like this
.
.
WebQuery = fxWebFunction(CustomerNumber),
CheckQueryResult = if WebQuery[SomeValue] = TRUE then WebQuery else fxWebFunction(CustomerNumber),
WebQueryResult = if CheckQueryResult[SomeValue] = TRUE then CheckQueryResult else "Error",
.
.
I obviously don't know what value you need to test for to see of the query succeeded, you'll have to insert that into the code.
There is try..otherwise built into PQ which is meant to catch errors but it doesn't always work as expected (it doesn't trigger on some errors), and it may not work for you anyway in this scenario as the error is from the web server and may not filter through to the PQ code as an actual error condition.
regards
Phil