Skip to main content
Question or a Poll
Q&A (Help Needed)extractorgeneric extractortrello api
Roman Zydyk
Data analyst @ PwC
Asked a question 3 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.

1 reply

Where am I?

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

Sign Up Now
Login Now
Martin MatejkaKeboola TEAM
Space Engineer @ Keboola
Answered 3 years ago

Hi Roman.

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

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.
1 comment
Roman ZydykMartin Fiser

Liked by Roman Zydyk and 1 other

Related Questions