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
⋅ 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/managing-data-presentation-json.
Please let us know in case of questions.
Regards,
Tanya
⋅ 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?
⋅ 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
