Skip to main content
Roman Zydyk
Data analyst @ PwC
Asked a question 2 years ago

Hello, I am using Generic extractor for Trello API. I am extracting Actions - https://developer.atlassian.com/cloud/trello/rest/api-group-boards/#api-boards-boardid-actions-get. I need to get only a few fields - card name, board name, list name, member ID and type. When I create the mapping and specify only these fields (data_card_name, data_board_name...) the result is empty column (probably because of the nested objects so the naming is different?). I also tried specifying "custom data type" for each nested object - treated as a table, but then I got a lot of separated tables. How to select only needed columns? I have already tried everything from documentation, but nothing seems to work. JSON response and result table are attached.

Where am I?

In Keboola you can ask and answer questions and share your experience with others!

Hi Roman.

If data is your root, then the mapping for card name field would be "card.name49". You can get inspiration here: https://developers.keboola.com/extend/generic-extractor/configuration/config/mappings/#directly-mapping-array50

There's table mapping used, but idea of locating that array with addresses is the same as when locating single field. I'm attaching example of one of my configs and the response from the API. You can see the main items array and then nested url of the webinar recording in the response and in the config the mapping "webinar-recording.url": "webinar_recording_url".

Hello, I am using Generic extractor for Trello API. I am extracting Actions - https://developer.atlassian.com/cloud/trello/rest/api-group-boards/#api-boards-boardid-actions-get. I need to get only a few fields - card name, board name, list name, member ID and type. When I create the mapping and specify only these fields (data_card_name, data_board_name...) the result is empty column (probably because of the nested objects so the naming is different?). I also tried specifying "custom data type" for each nested object - treated as a table, but then I got a lot of separated tables. How to select only needed columns? I have already tried everything from documentation, but nothing seems to work. JSON response and result table are attached.
Hello, I am using Generic extractor for Trello API. I am extracting Actions - https://developer.atlassian.com/cloud/trello/rest/api-group-boards/#api-boards-boardid-actions-get. I need to get only a few fields - card name, board name, list name, member ID and type. When I create the mapping and specify only these fields (data_card_name, data_board_name...) the result is empty column (probably because of the nested objects so the naming is different?). I also tried specifying "custom data type" for each nested object - treated as a table, but then I got a lot of separated tables. How to select only needed columns? I have already tried everything from documentation, but nothing seems to work. JSON response and result table are attached.