when trying to upload a template with 500 lines of data the readexcelsheet function was calling in interface to read those 500 lines in that only first 250 lines was fetching the function other 250 was not reading tried providing paging info too but still same only first 250 lines was reading
Could you please confirm what could be the reason for this issue
Discussion posts and replies are publicly visible
It's strange to see this issue.Have you tried using the readExcelSheetPaging function instead?
Also, validate your Excel tool plugin version, as major changes have recently happened to this plugin.
Thank you for details Yes tried using readExcelSheetPaging but getting below error could you please suggest on this and sure will check plugin version too
Looks like error you got at apn_isblank --> As you already doing .data so result.values are not required you can directly reference local!extractedData.values as output is datasubset.Have you tried readexcelsheetpaging in blank rule to check output?Make sure sheet number value should be 0 as it starts from 0 instead of 1(if you are reading 1st sheet).also remove startRow parameter
yeah it was 0 only and removed startRow parameter but getting conversion error like above shared snip
I edited my earlier response.Verify once.Looks like error you got at apn_isblank --> As you already doing .data so result.values are not required you can reference local!extractedData.values as output is datasubset.Have you tried readexcelsheetpaging in blank rule to check output?
Thank you!! Yeah got to see thank you and sorry that time i didn't able to see yes tried in blank rule it was returning output as list of variant now after correcting as you suggested getting again conversion error like below
Can you show me output of readexcelsheetpaging in blank rule?
sure please find the same Output Data was returning blank though there was valid data in uploaded template
Data is null here.Can you share the same output using readexcelsheet smart service?
yes please find the same can see the data
I can see you are able to fetch 1250 rows of data using readexcelsheet.Then how come you are experiencing first 250 lines was fetching the function other 250 was not reading?
means after uploading excel with 501 rows of data and after validating(readexcel completed) from those 501 first defined 250 was showing as valid data and second set of 250 is showing as invalid data even though the data is valid i tried swapping first set of data to second set and vice versa whatever the data that i gave first in 250 that data alone showing as valid rest other showing as invalid
How do you validating a data?Could you share logic where exactly you are facing this issue.
Thank you so much for all details was checking and working on the logic if there was any will update