SSIS package failures when calling API's

SSIS/Perl script failures

Description
I’m accessing the Zoom API’s using a Perl script, and the script is executed from an SSIS package. The script has been failing with an exit code 10060, which I believe is related to a connection. The script is failing between 1 and 2 a.m. The job is scheduled for 1:00 a.m.

The SSIS package is exececuted from a SQL Server Agent job.

Error
"“apReEYXKQZW7e2rSItJ15g==” “1632960000” “98214650543"” at “C:\sqladmin\dts\bin\perl”, The process exit code was “10060” while the expected was “0”.

Which App Type (OAuth / Chatbot / JWT / Webhook)?
JWT

Which Endpoint/s?
https://api.zoom.us/v2/report/meetings/{InstanceID}/participants

How To Reproduce (If applicable)
Steps to reproduce the behavior:
When Job runs

Additional context
Are there times when the API is not available?

Hi @dbailey,

This looks like it may be an environment specific error. Do you have any issues when you call this endpoint in Postman, using cURL from terminal, etc.?

Thanks,
Will

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.