We have a log that we've been asked to ingest which is a json format file that's similar to this:
{"type":"appRequest",
"severity":"INFO",
"eventid":"abcdefg1234567",
"userid":76965813945444,
"timezone":7,
"timestamp":"2019-10-30T23:57:59.958Z",
"logLevel":"INFO",
"url":"/some/url",
"diagnosticsEventId":"someEventId",
"startTime":1572479879958,
"logDetails":"200,OK"}
As you can see, the timezone is specified in a field instead of built into the timestamp string. I've look around to no avail, is there a way to specify the event timezone based on the timezone (this is offset to GMT in hours)?
... View more