cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Issue in parsing the date format using JSON parser

krupalibshah
Contributor

I have a simple pipeline as below,

image

The file contents are,

{
    "Time": {
        "_snaptype_localdatetime": "2017-12-12T10:51:12.013"
    },
    "BP_number": 2
}

When I use json parser and convert the time to string I get below output,

image

When using binary to document I get the correct output,

image

What is the JSON parser doing differently so as date is not getting converted to string?

4 REPLIES 4

krupalibshah
Contributor

Any help will be appreciated.

nganapathiraju
Former Employee

What is your expectation?

tstack
Former Employee

It looks like this file was generated by some of our code, did you download some preview data or use the DocumentToBinary snap?

Yes this file was generated using SL, I saw when I use JSON parser to read this file it does not convert the date into String but when I do it using binarytodocument it does it as require.