Hi,
I have a Canvas application and I have a gallery and I am filtering the Gallery and getting an EXCEL sheet export it from by using Plumsail custom connector in my flow, but my flow is failing on Parse JSON, well it was working before the last time I ran the flow.
Submit Button Code:
Set(ExportCSV, "");
Clear(ExportCSVFile);
ForAll(Gallery1.AllItems,
Collect(ExportCSVFile,{UserId:UserLabel.Text,Date:DateLabel.Text,TimeSlot:TimeSlotLabel.Text,Task:TaskLabel.Text,Customer:CustomerLabel.Text,Category:CategoryLbl.Text,Project:ProjectLabel.Text,DateAsInt:DateasInt.Text,Billable:BillLabel.Text}));
Set(VarURL, ExcelFileGenerate.Run(JSON(ExportCSVFile,JSONFormat.IndentFour)).created); Launch(VarURL)
1)
Ran 6 times
2)
Succeeded last time
3)
stuck on Parse JSON
JSON SAMPLE SCHEMA =
[
{
"Billable": "false",
"Category": "Others",
"Customer": "SunStar Hotels",
"Date": "03/08/2021",
"DateAsInt": "20210308",
"Project": null,
"Task": "Contd Excel File Task....",
"TimeSlot": "10:00 AM - 10:30 AM",
"UserId": "Muhammad Fahad Ali Khan"
},
{
"Billable": "false",
"Category": "Others",
"Customer": "Dewan Stores (Pvt) Limited",
"Date": "03/08/2021",
"DateAsInt": "20210308",
"Project": null,
"Task": "kuch bhi",
"TimeSlot": "10:30 AM - 11:00 AM",
"UserId": "Muhammad Fahad Ali Khan"
},
{
"Billable": "false",
"Category": "Others",
"Customer": "SunStar Hotels",
"Date": "03/08/2021",
"DateAsInt": "20210308",
"Project": null,
"Task": "create new task",
"TimeSlot": "09:00 AM - 09:30 AM",
"UserId": "Muhammad Fahad Ali Khan"
}
]
Any Help? ?
@LauraGB @eka24
