Question on date field format when using a!toJson

moritzw over 7 years ago

I am using a!toJson to create a json string on one of our environments. I use the rule output to put it in a text file.

In another environment I am reading the text file and use a!fromJson to convert it back to my CDT structure.

This is working fine with the exception of a date field which is formatted "YYYY-MM-DD" in the text file. If I change it to format "DD.MM.YYYY" the fromJson rule returns the right result.

Is there anyway to fix this besides manually changing all date fields?

TIA, Moritz

Discussion posts and replies are publicly visible

0 chetany
A Score Level 1
over 7 years ago

Can you please paste the relevant code snippet? Also are you getting any error?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 moritzw over 7 years ago

Well, there is not that much code involved. Basically toJson and fromJson.
There is no error, but the resulting date field looks something like that: 10/12/53163.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chetany
A Score Level 1
over 7 years ago

Can you send the JSON, I tried with the date format you mentioned and it worked.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 7 years ago

Does the json conversion issue only happen after writing to / reading from the text file, or can you reproduce it like in just an ordinary single expression?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 moritzw over 7 years ago

It only happens with the text file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 7 years ago

Can you somehow compare the raw JSON text sourced from the text file, with its equivalent original JSON string? I'm curious whether something like the particular text file encoding (which, i'm not sure what Appian defaults to) could be throwing off the a!fromJson interpretation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 moritzw over 7 years ago

I am putting the content of the txt file in a variable before I apply the fromJson function.
In the varable the content looks just the same as the toJson rule output.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 7 years ago

Just for troubleshooting purposes, can you pass the raw json text through the code() function? You could potentially compare that to system-generated json text, also passed through the code() function; my hope here is that if there are "invisible" differences messing things up, this might shed some light.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumaraveln over 7 years ago

Not sure if it helps .. But please try converting the date value to string before converting it to Json object .. Like toJson(toString(ri!yourDateVar))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel