I am creating a Zendesk support Source,the source has been created succesfully, but when connect that to MSSQL destination it gives me this `*ERROR* i.a.w.DefaultReplicationWorker(run):168 - Sync worker failed.`error in log while syncing data. Attaching log file for further reference. Thanks in anticipation. 😀

loading...

Hey @Alpana Shukla, I found this error at the end of your log file:

errors: $.access_token: is missing but it is required, $.credentials: does not have a value in the enumeration [oauth2.0], $.credentials: must be a constant value oauth2.0

I think you might have badly setup your source connection. We're moving our community support on Discourse soon, do you mind posting on the Troubleshooting forum if you'd like to follow up on this topic with our team?

This issue comes out in the logs, during the sync:

requests.exceptions.HTTPError: 404 Client Error: Not Found for url: <https://virkplan.zendesk.com/api/v2/business_hours/schedules.json?page=1>

Make sure you’re making API calls using Zendesk Admin account, this could be related. Also, try to sync only the schedules, to isolate the issue. This message should not affect the source sync or destination sync processes:

errors: $.access_token: is missing but it is required, $.credentials: does not have a value in the enumeration [oauth2.0], $.credentials: must be a constant value oauth2.0

I am using API token for authentication