Forum Discussion
Solved
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 usern...
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.
edhans
Community Champion
Community ChampionNot sure how your custom function looks exactly, but have you tried the:
try ... otherwise ...syntax?
Thanks, I will take a look at that one.
