Hi
I am using this component to upload the data to my Grid
At first I Export the excel file via Grid, Then I make changes to the Excel file that I have exported,
Now once I upload the Excel file back, So I have to convert the excel to JSON format, now after the conversion I am getting Invalid format for the values that are blak
I am attaching the example below
"Medical Device": ",
I am getting single quote this is just one key and value, I have around 30 rows and 200 cols
Columns that are populated with value number or text it is working fine.
Only issue is with blank fields.
ThanksTousif Khan
@Tousif Khan
This can happen when converting between CSV and JSON as the JSON can ignore columns that are empty. You should set 'Serialize Default Values' to Yes so that all columns are converted to the CSV, not just those with values.Best,RAD Manage
Hi actually the export excel is been exported by grid, and yes we need those empty fields on excel,
It is already set to Yes
Are you saving the import data before you attempt to convert the inbound payload to json or trying to convert directly from the upload?
So The file I got from Export is excel xlsx file then I make changes to the data which is presented in that excel,
I made changes to the excel that I have downloaded.
Then upload it and once I get the binary excel file to my Local variable, pass this file to Client action that this component has, then it convert the data and return the output as json