Hello all, I am trying to parse PAC Control data into Excel using a Groov Epic. Has anyone done this?
I was able to generate a URL via Swagger and can read the data in a web browser, but I am having a lot of difficulties pulling the data into Excel.
I’ve tried using the Excel Spreadsheet from this example and no luck (https://www.opto22.com/support/resources-tools/downloads/opto22_snap_pac_restfulpac_msexcel-zip). I put in my IP address and credentials and when I try to look for data I get an error that says:
“System Error: The certificate authority is invalid or incorrect”
I’ve also tried pulling it directly in a blank Excel Spreadsheet using the Data tab, and then “From Web” but that does not work either.
Any help would be greatly appreciated as well as an instructional if available.