Hi everyone,
I hope you are well!
I have tried the ClickUp Pack but it seems there is a problem in getting information from custom fields with it (data stays empty if a field is not native).
Therefore, I am trying to create a table with a lot of data in it, that I could use in my Coda doc.
I have set a webhook to send me data each time I modify something in ClickUp.
It works fine if I want to get data from simple fields in my table, like name, priority, etc.
This is the formula I am using: [Step 1 Result].ParseJSON("payload.name")
Now, I am trying to get the content of my custom fields. Let us imagine I would like to find my value for my custom field N°153f68c4-1f31-4d3a-9bd9-6ad9e0a18003. I should find “myurl1.com”.
I do not know how to do it (and tried several options without success, also searched around). I am not an expert in coding either, but usually understand simple things.
Would you be able to help me by any chanceand let me know which formula should let me find the value “myurl1.com”?
Here is the code (that I have shortened to ease research):
[
{
"headers": {
},
"params": {},
"query": {},
"body": {
"auto_id": "",
"trigger_id": "",
"date": "2025-05-17T12:37:40.483Z",
"payload": {
"id": "8698t5k3k",
"name": "My Name",
"priority": "1",
"fields": [
{
"field_id": "153f68c4-1f31-4d3a-9bd9-6ad9e0a18003",
"value": "myurl1.com",
"value_options": null,
"value_deleted": false,
"value_richtext": null,
"reasoning": null,
"task_id": "8698t5k3k",
"type": 0
},
{
"field_id": "1da271eb-c484-4d5a-b7e8-0513fea6376a",
"value": "myurl2.com",
"value_options": null,
"value_deleted": false,
"value_richtext": null,
"reasoning": null,
"task_id": "8698t5k3k",
"type": 0
},
{
"field_id": "fa8a0e4b-f8ab-4c14-ad1d-e551846e4219",
"value": "My Address - Country",
"value_options": null,
"value_deleted": false,
"value_richtext": null,
"reasoning": null,
"task_id": "8698t5k3k",
"type": 15
}
],
"attachments": [],
"docs": [],
"_version_vector": {
"workspace_id": 9012356491,
"object_type": "task",
"object_id": "8698t5k3k",
"vector": [
{
"master_id": 14,
"version": 1744888861606000,
"deleted": false
},
{
"master_id": 15,
"version": 1747485457862000,
"deleted": false
}
]
}
}
},
"webhookUrl": "",
"executionMode": ""
}
]
Thank you very much for your help.