I am trying to use coupler.io
to pull the data from CATS and then put it into excel for cstom excel reporting purposes
The columns names are very complex, as I can't put in ID. For example, the column name for Job ID from the candidates table is "_embedded.candidates.0._embedded.activities.0.regarding_id"
How do I know what is what, as the 0 is sometime a different number. IE 0, 1.