Using automation to update Insight object date attribute

[Colin Franco]

Hi,

Perhaps someone can spot my error or guide me on using automation to update an insight object date field. My automation fires, and gets a 200 response, but the attribute value does not change.

Scenario:
I have an insight schema containing a table of objects which represent tasks to be done at predetermined times.

I'm creating an automation rule that performs an IQL query to select the objects representing tasks which need to be done today. The results of this query are used to generate issues, one per object, and then to update the insight object with a "last run" date the current date.

• Currently, manual trigger is used while testing
• IQL identifies the correct objects
• If block with advanced compare sets up for processing of result list
• For each block implements list smart value
• The Create Request step does indeed creates all the necessary requests, including updating an object custom field with the details of the insight object that relates to the new issue
• A Send web request step pushes an update to the API for that object, and waits for results
• A final mail step (for debugging) send me the details of the return object - headers and body - which I believe confirms that my request URL and authorization must have worked. The return code is always 200

The problem is that the web request to update the date does not update the date, nor does it throw any errors.

The code looks like this:
{
"attributes": [
{
"objectTypeAttributeID": "384",
"objectAttributeValues": [
{
"value": "{{now}}"
}
]
} ]
}

I have triple checked the objectTypeAttributeID - it is correct for the attribute I want to update and it is a date object.

If I use a literal instead of the smart value for the date, the result is unchanged.

What trick am I missing?

[Laurent Buset]

Hi,

You've to add .jiraDate

{{now.jiraDate}}

Laurent