Nesting attachments array from Zendesk Support connector into a separate table in MySQL

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is looking for a way to nest the attachments array from Zendesk Support connector into a separate table in MySQL.


Question

Hi all! I have a connection between Zendesk Support and Mysql DB to export all tickets and comments. Comments is a json with an array of attachments of this comment. In previous versions of Zendesk Support source connector, this attachments array creates a new table in mysql with the data. Is there any way to nest this array into a separate table?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["zendesk-support-connector", "mysql-db", "json", "attachments-array", "nesting", "separate-table"]