topic Re: Do not break foreach loop when API fails in Workato Pros Discussion Board

Do not break foreach loop when API fails

bhavesh-patel — Thu, 23 Feb 2023 13:25:30 GMT

Issue is inside custom connector ruby code.

Context: I have a list of companies in an array then I am using .each method to loop every company and then hitting an api call on every company.

Problem: Now one api call is failed for a company and code breaks. I don't want code to break, instead I want loop to continue as we use try catch in many languages to prevent breaking of loop. How to acheive the same in Custom Connector SDK using ruby.

Re: Do not break foreach loop when API fails

bhavesh-patel — Thu, 23 Feb 2023 14:15:55 GMT

My API call is as below:

company_ids.each {

|company_id|

puts("company_id: #{company_id}")

companyobject = post("#{base_url}/api/v2/labor-model/location/#{company_id}/run").payload(start:start_unix, end:end_unix).headers("Authorization": auth_header).

after_error_response(400, 401, 404, 417, 500) do |code, body, header, message|

error("#{message}: #{body}")

end

puts("companyobject: #{companyobject}")

}

Re: Do not break foreach loop when API fails

meghan-legaspi — Mon, 27 Feb 2023 15:36:33 GMT

Hey @bhavesh-patel,

I think this page on ruby loops could be helpful for you: https://www.tutorialspoint.com/ruby/ruby_loops.htm

You can also find more variations of 'each' here: https://docs.workato.com/developing-connectors/sdk/sdk-reference/ruby_methods.html#each

Please let me know if you find your solution within those pages!

Cheers,
Meghan

Re: Do not break foreach loop when API fails

gary1 — Mon, 27 Feb 2023 16:58:45 GMT

I'm not sure if begin/rescue or catch/throw are supported in a custom connector, but you should give them a try. They aren't supported in the Ruby recipe connector (I tried and confirmed with Workato support) but the connector SDK tends to have broader Ruby support.

https://www.geeksforgeeks.org/ruby-exception-handling/

Here's an example:

companies.each { | company |
x = {}
begin
x.split(';') # example that will throw error
# put your API call here
rescue
puts "error is skipped"
end
}

Re: Do not break foreach loop when API fails

chris-wiechmann — Tue, 28 Feb 2023 09:33:46 GMT

Ruby exception handling is unfortunately also not supported in the SDK-Code.

Re: Do not break foreach loop when API fails

bhavesh-patel — Mon, 06 Mar 2023 05:11:16 GMT

There is no support for exception handling so I have move this code on the recipe level and then I used repeat action in a parent recipe on my company array and then every action goes to a child recipe where I use monitor block of recipe to handle exception from API. Then I move every error into lookup table.