Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

show embedded json object

Answered
Michel Roger asked on July 6, 2020

Hello,
 
I am trying to display the correct data on the table from my json datasoruce for datatime field represented below, but it does not display correctly. Any help is appreciated it .

"systemUpdatedDate": {
"$date": "2020-06-12T15:54:51.556Z"
}

as this 

mapping: {
'systemUpdatedDate.$date': {
type: 'datetime'
},

4 answers

Public
Milena Pechura Milena Pechura Flexmonster July 7, 2020

Hello, Michel, 
 
Thank you for writing to us.  
 
Please note that nested JSON format is not supported in Flexmonster. Further details could be found in Connecting to JSON article.
 
We recommend preprocessing your data to the plain format:

  {
    "$date": "2020-06-12T15:54:51.556Z" 
  }

"systemUpdatedDate" could be defined as a dimension using dimensionUniqueName and dimensionCaption

We would like to mention that array data type is not available in the component. The possible workaround is to split the array into several objects.
Please change this structure:  


“key1”: “value1”,
“key2”: [“value21”, “value22”] 
}

 to this


“key1”: “value1”,
“key2”: “value21” 
},
{
“key1”: “value1”, 
“key2”: “value22” 
}

Also, to display all fields on the grid when using Mapping, an empty object should be specified for every field: "fieldName":{}
This works with JSON format, while when using CSV these fields could be just skipped. 
 
Please have a look at the example we have prepared for you. 
 
Do not hesitate to contact us in case additional questions appear. 
 
Regards,   
Milena

Public
Milena Pechura Milena Pechura Flexmonster July 9, 2020

Hello, Michel,
 
We have received your email about dimensionUniqueName and dimensionCaption, please see our answer below.

These properties should be defined in the Mapping object, and are used to group several fields under one dimension. Please see the following code snippet for the reference:

mapping: {
"$date": {
dimensionCaption: "systemUpdatedDate",
dimensionUniqueName: "systemUpdatedDate"
}
}

Please let us know if you have any additional questions.

Regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster July 16, 2020

Hello, Michel,
 
Our team is interested in whether you tried preprocessing your data to the plain format.
Were our responses helpful, or perhaps you still have any questions we can help you with? 
 
Looking forward to hearing from you.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster July 24, 2020

Hello, Michel,
 
We were wondering if our response helped you with your question.
Please let us know if it worked for your case.
 
Looking forward to your response.
 
Kind regards,
Milena

Please login or Register to Submit Answer