@john_baughman My recommendation for doing something like this would honestly be directly from Chef (or from the system running chef) and just using a script to generate, download, cleanup the report you need with the information necessary. Something like this script - modified for your needs - is likely what I would do:
That way you get the report generated, downloaded, and chef can process it without needing to worry about the size of the report or anything else since it doesn’t appear that InsightConnect is being used for any real processing in this specific case.
Another option would be to use Chef’s http_request resource instead of having a script being run: https://docs.chef.io/resources/http_request/