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

[Ergun]

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

[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"
  }
}

[Ergun]

How can i get the idCard and customField.id?

[Daydreamer Mike]

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

[Ergun]

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.

[Ergun]

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.

[Daydreamer Mike]

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}"

[Daydreamer Mike]

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