JSON integration issue with Date column

Answered
Sidath asked on July 15, 2019

Hello,
 
We use FlexMonster in web and use JSON integration. The issue is with a date. Sometimes, one of our date column has null value then that time report will consider that column as string column instead of the Date column. Because of that, we will lose date drill down. How can we force flex monster to use a date column instead of a string. 
 
Thanks
Sid
 

3 answers

Public
Tanya Gryshko Flexmonster July 15, 2019

Hello, Sid,

Thank you for writing to us.

For your case, we kindly suggest configuring the data types in JSON. Our team suggests reading the following tutorial: https://www.flexmonster.com/doc/data-types-in-json/.

Please let us know in case of questions.

Regards,
Tanya

Public
Sidath July 17, 2019

Hello,
Thanks for your reply. I can understand the tutorial but we build json string in C# using  JsonConvert.SerializeObject. I did not see any json decorator that I can use in C# model to built json string with the attribute type. Did you guy’s have any idea?   
 
 

Public
Vera Didenko Flexmonster July 17, 2019

Hello, Sid,
 
Thank you for your response.
 
We kindly suggest composing the JSON meta object with the specified data types separately and then adding it at the beginning of the JSON data.
 
Please let us know if everything works.
 
You are welcome to contact us in case questions arise.
 
Best Regards,
Vera

Please login or Register to Submit Answer