Has anyone had any success using PowerBI to generate API requests and ingest JSON data from Rapid7 to use for reporting functionality?
I’m trying to use the Web data connector, a URL i.e. https://eu.api.insight.rapid7.com/connect/v1/jobs?status=failed, but im having trouble getting the API key to work correctly with it