Schema change on shortcuts table

[cgilj]

While trying to run an extraction, the job failed in the following way

Error persisting data to Stitch: 400: {'error': 'Record 714 for table shortcuts did not conform to schema:\n#: #: no subschema matched out of the total 2 subschemas\n#: expected: null, found: JSONObject\n#: extraneous key [agents] is not permitted\n'}

Checking the error message and Zendesk Chat API, seems that there's a new field agents on shortcuts table which does not exist on the current schema.

I saw an issue was opened some time ago for this same reason

#15

However, the fix does not seem to include an agents item on shortcuts schema, but a scope item on agents schema (which does not actually exist on Zendesk Chat API). Might there have been some confusion?

#16

Zendesk Chat API Docs

Current tap schema

https://github.com/singer-io/tap-zendesk-chat/blob/master/tap_zendesk_chat/schemas/shortcuts.json

I believe we would need to add something like

"agents": {
      "type": [
        "null",
        "array"
      ]
    },

Please let me know if this sounds accurate and if I can open a Pull Request myself to fix the issue. Thank you very much!

[nickjl]

hey @cgilj

did you get any further with this? running into same error and getting shortcuts out of zendesk is a nightmare! do you have any work around?

thanks 😁

[katered8]

im also getting this error on every run ☹️ any updates?