I am working on using the trello Labels to identify the teams and states with-in trello and have the movement from one list to another to trigger updates to excel and send emails. The label Name is what I am looking to pull into the excel file and populate the column.
{
"id": "5cddc331cf6316498f74f4d1",
"checkItemStates": null,
"closed": false,
"dateLastActivity": "2019-05-20T19:38:26.236Z",
"desc": "Sales Rep: bwhitley@kccmfg.com\n\nETO REQUEST INFORMATION:\nRequest Number : ETO201931\nJob Name: Stuff\nSales Rep: Nobody\n\nDescription of Request:\n[\"OAB\"]\n\nEverything\n\nIs this a rush Order?\n No\n\nYou can find the updated excel file at:\n\nhttps://teams.microsoft.com/_#/xlsx/viewer/teams/https%3A~2F~2Fkccmfg.sharepoint.com~2Fsites~2FEngineeringChangeRequest~2FShared%20Documents~2FCompleted%20ECR%20Forms~2FQPF8.3.2.6.1%20%20ETO%20Request%20Form.xlsx?threadId=19%3A745affdae5c149089cbaa94403fa3c76%40thread.skype&baseUrl=https%3A~2F~2Fkccmfg.sharepoint.com~2Fsites~2FEngineeringChangeRequest&fileId=45C771C2-4AD6-4C94-B3E4-651E6F1D0714&ctx=files&viewerAction=view",
"descData": null,
"dueReminder": null,
"idBoard": "5cd337ef1288766d5b07eb3d",
"idList": "5cdc18d11187422f55378da0",
"idMembersVoted": [],
"idShort": 13,
"idAttachmentCover": null,
"idLabels": [
"5cd337ef91d0c2ddc5246a31"
],
"manualCoverAttachment": false,
"name": "ETO201931",
"pos": 8192,
"shortLink": "whqZ7smM",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 4,
"checkItemsChecked": 4,
"comments": 0,
"attachments": 0,
"description": true,
"due": "2019-05-18T20:08:00.000Z",
"dueComplete": false
},
"dueComplete": false,
"due": "2019-05-18T20:08:00.000Z",
"idChecklists": [
"5cddc331cf6316498f74f4d4"
],
"idMembers": [],
"labels": [
{
"id": "5cd337ef91d0c2ddc5246a31",
"idBoard": "5cd337ef1288766d5b07eb3d",
"name": "Approved",
"color": "green"
}
],
"shortUrl": "https://trello.com/c/whqZ7smM",
"subscribed": false,
"url": "https://trello.com/c/whqZ7smM/13-eto201931"
}
