nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to update a custom date field with data from external http response

Ergun_txts39

Hi,

I have an automation where a http request is made to external url (populated with card data) and need to use a date field in the returned httpresponse json to update a custom date field.

However for updating a date field I could not find the option to use a variable.

Does anyone have an idea how to implement this?

Thanks a lot

Accepted answers

All comments

Mike - Dreamsuite Consulting

Hi,

Please take a look at this section of the documentation to see how responses work.

https://support.atlassian.com/trello/docs/issuing-http-requests/#Response

I have had to play around with this a little bit to get it to work. It doesn't handle complete arrays but you can have array items. For example, in this one I am gathering data from a location API

post comment "Lat:{httpresponse.results[0].geometry.location.lat}\nLong:{httpresponse.results[0].geometry.location.lng}"

I tend to get the response structure by using this tool to help guide me:

https://reqbin.com/post-online

Ergun_txts39

I was able to post the response as comment, but what i want to to is update a custom field of data type date with the reponse data.

This i could not do.

Adam Cao

So you can use the custom field endpoint:

PUT `cards/${idCard}/customField/${customField.id}/item`

With a JSON body that looks like this:

{
  "value": {
    "date": "2023-08-31T13:01:01.222Z"
  }
}

Mike - Dreamsuite Consulting

Ahhh, yes I did come across this too and had to use the comment as a kind of parser....

A little clunky but it works...

When a comment containing "Lat:{*}" is posted to a card, set custom field "Field" to "{wildcard1}"

Ergun_txts39

How can i get the idCard and customField.id?

Mike - Dreamsuite Consulting

https://developer.atlassian.com/cloud/trello/rest/api-group-cards/#api-cards-id-get

Ergun_txts39

I am running the url request from a card button. Is there not a way to access it without having to make a request? I mean the cardId is already known as I am calling the action through that card button.