Is there a function to insert current datetime?

[jag959]

Need assistance on trying to insert the current date/time using Jolt.

I tried (as shown below) using "${now()}"; but the output is not producing the date/time.

JSON input:

[
  {
    "ProdId": "Filler",
    "ProductName": "Z Dry Filler",
    "Trait": "",
    "Variety": "",
    "SuggestedRetailPrice": "0.0000",
    "CropId": "",
    "DeptId": "067001"
  },
  {
    "ProdId": "Clay",
    "ProductName": "Z Clay",
    "Trait": "",
    "Variety": "",
    "SuggestedRetailPrice": "0.0000",
    "CropId": "",
    "DeptId": "067001"
  }
]

Jolt Spec:

[
  {
    "operation": "default",
    "spec": {
      "*": {
        "LastUpdated": "${now()}"
      }
    }
}
]

Output:

[ {
  "ProdId" : "Filler",
  "ProductName" : "Z Dry Filler",
  "Trait" : "",
  "Variety" : "",
  "SuggestedRetailPrice" : "0.0000",
  "CropId" : "",
  "DeptId" : "067001",
  "LastUpdated" : "${now()}"
}, {
  "ProdId" : "Clay",
  "ProductName" : "Z Clay",
  "Trait" : "",
  "Variety" : "",
  "SuggestedRetailPrice" : "0.0000",
  "CropId" : "",
  "DeptId" : "067001",
  "LastUpdated" : "${now()}"
} ]

Desired Output:

[ {
  "ProdId" : "Filler",
  "ProductName" : "Z Dry Filler",
  "Trait" : "",
  "Variety" : "",
  "SuggestedRetailPrice" : "0.0000",
  "CropId" : "",
  "DeptId" : "067001",
  "LastUpdated" : "2018-03-06T15:38:19Z"
}, {
  "ProdId" : "Clay",
  "ProductName" : "Z Clay",
  "Trait" : "",
  "Variety" : "",
  "SuggestedRetailPrice" : "0.0000",
  "CropId" : "",
  "DeptId" : "067001",
  "LastUpdated" : "2018-03-06T15:38:19Z"
} ]

I'm not sure Jolt can even accept such variables.

Thanks in advance for any assistance.

[milosimpson]

https://help.github.com/articles/creating-and-highlighting-code-blocks/

[milosimpson]

There is no way to ask jolt for "now". Gets into a messy world of date formatting.

I recommend "ninjaing" the data to the json first, and then using Jolt to push that data to all the places you want it to go.

[milosimpson]

For example, if you could fix your input "before jolt" to be

Input

{
  "ninjaed-in-time": "2018-03-06T15:38:19Z",
  "list": [
    {
      "ProdId": "Filler",
      "ProductName": "Z Dry Filler",
      "Trait": "",
      "Variety": "",
      "SuggestedRetailPrice": "0.0000",
      "CropId": "",
      "DeptId": "067001"
    },
    {
      "ProdId": "Clay",
      "ProductName": "Z Clay",
      "Trait": "",
      "Variety": "",
      "SuggestedRetailPrice": "0.0000",
      "CropId": "",
      "DeptId": "067001"
    }
  ]
}

Spec

[
  {
    "operation": "modify-default-beta",
    "spec": {
      "list": {
        "*": {
          "LastUpdated": "@(3,ninjaed-in-time)"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "list": ""
    }
  }
]

Would generate the output you want.

[jag959]

Thank you.

[Joseph2424]

What does "ninjaed" stand for?

[milosimpson]

In this context it means "sneak". Before Jolt, "sneak"/"ninja" in an extra field, and then use Jolt to pull/use that field.

[Joseph2424]

How can you accomplish this in Java? Any suggestions?