Export Report in CSV format using a script

knowledgeenthus
Kilo Contributor

‎01-11-2018 10:52 AM

Hi,

I have figured out a script to export report using csv format which is great but i cant export more than 50,000 records

I have tried the logic of looping through and exporting 50,000 records at a time and combine them at the end but specifying a number in   sysparm_first_row gets ignored and it always results the first 50,000. Is there any other way around this? I am using powershell if anyone has expertise in that area

  • 2,988 Views
10 REPLIES 10

knowledgeenthus
Kilo Contributor
In response to knowledgeenthus

‎01-11-2018 03:45 PM

so i tried this



Invoke-webRequest -OutFile "Path\report.csv" -Uri "https://instance.com/sys_report_template.do?CSV&jvar_report_id=b2343242h24324hbg24e2&sysparm_orderby..."



THis gave me 50,000 records arranged by correlation id. Then i tried this



Invoke-webRequest -OutFile "path/Report.csv" -Uri "https://instance.com/sys_report_template.do?CSV&jvar_report_id=basfoffhfffdss&sysparm_query=u_correl..."



But this gave me the same 50,000 rown, i used the %3E to specify greater than to get the next 50,000 rows. Any idea what i am doing wrong?



you can ignore the report id number as i just made up for the sake of the example


0 Helpfuls