All the cards have the same custom fields, some of them can be empty, but I don’t think that’s a problem right? The structure is the same.
Some of the fields are not text, so I think I must create a logical expression somewhere to insert the correct data into sheets.
[
{
"id": "635904193bd194021cfbbffe",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 0,
"checkItemsChecked": 0,
"checkItemsEarliestDue": null,
"comments": 2,
"attachments": 0,
"description": true,
"due": null,
"dueComplete": false,
"start": null
},
"checkItemStates": [],
"closed": false,
"dueComplete": false,
"dateLastActivity": "2022-10-26T09:58:08.829Z",
"desc": "Lenovo X250",
"descData": {
"emoji": {}
},
"due": null,
"dueReminder": null,
"email": null,
"idBoard": "6346e8745d10ef037709bbcf",
"idChecklists": [],
"idList": "634d6e1c9db7c200797f30c7",
"idMembers": [],
"idMembersVoted": [],
"idShort": 183,
"idAttachmentCover": null,
"labels": [],
"idLabels": [],
"manualCoverAttachment": false,
"name": "matheus - teste",
"pos": 4096,
"shortLink": "dg5b4H7l",
"shortUrl": "https://trello.com/c/dg5b4H7l",
"start": null,
"subscribed": false,
"url": "https://trello.com/c/dg5b4H7l/183-matheus-teste",
"cover": {
"idAttachment": null,
"color": null,
"idUploadedBackground": null,
"size": "normal",
"brightness": "dark",
"idPlugin": null
},
"isTemplate": false,
"cardRole": null,
"customFieldItems": [
{
"id": "635904236d6eff00b4ac6efd",
"idValue": "6346e8dfd9040d001803108e",
"idCustomField": "6346e8dfd9040d001803108c",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "6359042bce529704b03c8897",
"value": {
"text": "Matheus"
},
"idCustomField": "6346e8dfd9040d0018031106",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "63590430fb86d304795e1111",
"value": {
"number": "939999999"
},
"idCustomField": "6346e8dfd9040d0018031109",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "6359043968d8f5005ac12b51",
"value": {
"text": "[email protected]"
},
"idCustomField": "6346e8dfd9040d0018031163",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "6359043b715efe040d574cd6",
"idValue": "6346e8e0d9040d0018031221",
"idCustomField": "6346e8e0d9040d001803121e",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "6359043f37d8c9022983f75e",
"value": {
"text": "Morada"
},
"idCustomField": "6346e8e0d9040d0018031298",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "635904432e16b70207b1f4d4",
"value": {
"text": "Traking Code"
},
"idCustomField": "6346e8e5d9040d001803193b",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "63590444754add03e1d17abb",
"idValue": "6346e8e5d9040d00180319da",
"idCustomField": "6346e8e5d9040d00180319d8",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "63590447df4195010551e5d0",
"idValue": "6346e8e5d9040d00180319e4",
"idCustomField": "6346e8e5d9040d00180319e3",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "635904480a049701f640634f",
"idValue": "6346e8e5d9040d00180319ec",
"idCustomField": "6346e8e5d9040d00180319eb",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "6359044e65469b11a8a21fc6",
"value": {
"text": "10001221"
},
"idCustomField": "6357f39e0d5ead0085b00f9d",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "63590450225f7a00a19d7767",
"value": {
"text": "ASD14SA31ASD3"
},
"idCustomField": "6357f3a9d3334202cba5ed1c",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
},
{
"id": "63590458abc94906218a716e",
"value": {
"number": "50"
},
"idCustomField": "6357fadaacdcb204963566c8",
"idModel": "635904193bd194021cfbbffe",
"modelType": "card"
}
]
}
]