Forum Discussion
Handle an error in a custom function
I have a custom function that queries an API for some data and loads it into a table. I plan on using this function as a column (invoke custom function) to query data from the API based on the usernames in the 1st column. Now, what I have works so far, but with some username requests to the API, it doesn't return any data. This is causing an error, and the table stops processing at the first user that kicks out an error when I try to expand the new column.
Is there any way I can handle this better in my query/function so it can keep going, and just creates null data instead of an error?
Hope this makes sense...
PQ will not automatacally handle the errors, by design. What should it do? Replace with null, replace with blank, replace with the word "Error?"
The Try/Otherwise construct is exactly for trapping errors and you could use:
try HereIsSomeMath otherwise nulland if it gets an error, it will replace with null. It is a good error handler. LIke IFERROR() in Excel.
5 Replies
Not sure how your custom function looks exactly, but have you tried the:
try ... otherwise ...syntax?
Thanks, I will take a look at that one.
Ok, well I just replaced "errors" with "null" and then expanded the table, and that worked as I had hoped. However, I'm still curious if there is a way to automate that in the query itself so I can write it into future queries to just kinda handle the errors without having to do anything
PQ will not automatacally handle the errors, by design. What should it do? Replace with null, replace with blank, replace with the word "Error?"
The Try/Otherwise construct is exactly for trapping errors and you could use:
try HereIsSomeMath otherwise nulland if it gets an error, it will replace with null. It is a good error handler. LIke IFERROR() in Excel.
I know it is a year late but just came across this thread when trying to debug a similar problem. I found that it works if I expand the columns when I invoke the function rather than in the function itself. Hope this helps.
