🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

JSON integration issue with Date column

Sidath asked on July 15, 2019

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. 

3 answers

Tanya Gryshko 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.


Sidath July 17, 2019

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?   

Vera Didenko 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,

Please login or Register to Submit Answer