The scenario is that I am using Matillion to pull records from AXON Evidence using the AXON api.
Specifically I want to request pages of data from one of their standard reports. I've previously manually extracted this report from the AXON web portal and used that for wider reporting. Now I want to pull the report pages into Matillion using the api.
AXON have their own api explorer where I have been able to successfully request a bearer token and have made simple calls, including pulling one page of data from the specific report I'm after.
I was able to use the json from that response to create an api query profile and then use the api query component to load the data to a table in Snowflake (following this page in the docs).
Here's what I'm not understanding ...
Does that query profile only reference the extracted data in the json file? In other words is it essentially a point-in-time snapshot?
I can't see where the actual AXON URI is referenced in the RSD file or entered in the query component?
Even in the IP ranges example in the docs page referenced above the RSD file says <api:set attr="uri" value="ip-ranges.json" />, so the example is much the same as my attempt and does not reference the IP Ranges URI that I can see (I expected to see something like https://ip-ranges.amazonaws.com as the uri).
I have also tried to create a query profile by directly entering the AXON URI in the New Endpoint dialogue but can't get that to work.
When I click "Send" I get the response: "Exception caught when running HTTP Request. Check logs for more information." The log says: "[Error]: Exception caught when running HTTP Request. EOFException: SSL peer shut down incorrectly"
I recall seeing something about issues with https uri so I tried changing the uri to http. This gives the following ...
Response: "Http response has returned a status code representing failure. Check logs for more information."
Log:
The AXON docs say the 403 code is “Forbidden”. “The client is not authorized to use the resource. Unlike 401 Unauthorized, the client’s identity is known to the server.”
I assume I’m getting 403 because http access is forbidden as I can use the exact same URI (with https) in the AXON api explorer and it runs without an issue (this is what I did to get the json response ot create the query profile).
I feel like I’m missing something fundamental here (you’ll probably all be shaking your collective heads in disbelief at my newbie ignorance). Can anyone nudge me in the right direction?
Stew
