jsonPath error using $__isoFrom()

[birgirob]

Hello,
I'm getting this error when trying to use $__isoFrom() variable in the Fields tab

The response JSON looks like this:

{ 
  "issues": [
    "fields": [
      ...
      "created": "2020-11-20T12:37:36.000+0000"
      ...
    ]
  ] 
}

Am I doing something wrong?

[marcusolsson]

Does it work if you surround the macro with double quotes?

[birgirob]

Thanks for the quick response.

If I use quotes the error goes away but it doesn't return anything

Same with single quotes.

It should definitely be returning data since hardcoding the date in the body works:

{
    "jql": "issueFunction in subtasksOf('project = MIS') and created > '2020-05-31 15:24'"
}

Shame ISO8601 dates aren't valid in Jira JQL, then I could use params instead of body

[marcusolsson]

The query looks right, though I see now that the response JSON you posted doesn't seem to be valid JSON.

The following works for me. I tried changing the time interval as well to confirm that the filter works:

Response:

{
  "issues": [
    {
      "fields": [
        {
          "created": "2020-11-20T12:37:36.000+0000"
        }
      ]
    }
  ]
}

Query:

$.issues[*].fields[?(@.created > "$__isoFrom()")].created

[birgirob]

Seems like I made a typo in the JSON above, but now that I look closer at the response, "fields" is actually an object not an array. It should still work, right?

Response:

{
  "issues": [
    {
      "fields":
        {
          "created": "2020-11-20T12:37:36.000+0000",
          "someOtherField": "value"
        }
    }
  ]
}

[birgirob]

Think I got it working. Maybe should have read JSONPath Plus docs earlier, it has some nice examples :)

This is how I am selecting the 'created' field, a bit convoluted but does the job (can you see a way to simplify it? :))

$.issues[*].*[?(@property === 'created' && (@ > '$__isoFrom()' && @ < '$__isoTo()'))]^.created

Thanks for the help!