show embedded json object

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

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

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

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

Hello, Michel,
 
Thank you for giving an update on your progress.
 
Our team would like to confirm that it is possible to modify the data passed to Flexmonster without applying changes to the database.
 
We suggest preprocessing your data to the plain JSON using a server-side or client-side script. Please note that writing a server-side script is a more efficient approach.
The script should take nested JSON, change it to the plain JSON, and return the new dataset. Please specify the link to the script in the 'filename' property of the data source object.
 
Do not hesitate to contact us if any further questions arise.
 
Best regards,
Milena

Hello, Michel,
 
We are just checking in to ask if you’ve found our response helpful.
Have you tried writing the script to preprocess your data? 
 
Looking forward to hearing from you.
 
Kind regards,
Milena

Hello, Michel,
 
Thank you for providing details about the desired preprocess logic.
 
Taking into account your case, we would like to confirm that it is possible to create a hook on the frontend.
To pass the data to Flexmonster after preprocessing, we suggest using Ajax. Further details about this approach can be found in the following forum thread: https://www.flexmonster.com/question/execute-a-function-behind-filename-get-url-execution/#answer-18991
 
Please keep us posted on your progress and do not hesitate to contact us in case any questions arise.
 
Best regards,
Milena

Hi, Michel,
 
Hope you are doing well!
 
Our team would like to kindly take an interest in whether you tried the suggested approach. Could you please let us know if it helped?
 
We would be happy to hear your feedback.
 
Kind regards,
Milena 

Hello, Michel,
 
How are you?
 
We are just checking in to ask if you have found our response helpful.
Have you tried the approach with Ajax? Does it work for you?
 
Waiting for your reply.
 
Best regards,
Milena