Zendesk custom ticket fields missing

Found a work-around for this issue.

It might not be the best solution, but it works for smaller databases.

1) Get data -> make sure to get the "Tickets" table

2) Edit query

3) Duplicate the "Tickets" table (right-mouse -> duplicate)

4) Remove all columns except "Ticket ID" and "Custom fields"

5) Press the arrows of the "Custom fields" column -> "Expand to new rows"

6) Press the arrows of the same column -> Select both "ID" and "Value" and press ok.

7) Change the type of the "Custom_fields.ID" into a whole number and the "Custom_fields.Value" field into a string.

8) Highlight "Custom_fields.ID" -> go to "Transform" tab -> "Pivot Column"

9) Make sure to select "Custom_fields.Value" AND press the (almost hidden) advanced tab in the window, select: don't aggregate

10) You can now change the titles of the custom fields ID so it is easier to work with. 

11) Close and save the query editor

That's it. You now have a table which you can link to your ticket IDs in the "Relationships" window. Good luck!