Kenna API Data Insert to SQL DB: Is it possible to use our Alteryx API service account

Management of our present asset vulnerability database requires multiple exports to csv and a large volume of time spent manually parsing data to come up with a listing we can act on of new or unacknowledged and stagnant vulnerabilities. EDC Senior leadership is looking to automate this scope area identifying and taking action against these latent risks within our data centers.

This is the overarching goal of this project. We should be able to make use of api hooks to populate newly created table(s) in the EDC-Foundations SQL DB; once populated we should be able to aggregate the data and relate it to the ongoing remediation work that will be populated from our Cherwell api connection.

Thanks in advance.

Best Practices

API

Accepted answers

brentmarion23

Problem solved. I just had to determine by base url, and get the correct token for authentification.

www.api(company_name).kennasecurity.com/assets/(ID)

Thanks,

Brent

All comments

Thableaus

Hi @brentmarion23

From what I understood you want to connect to Kenna Security through an API and automate the export of some useful tables in there using Alteryx, right?

You might be able to leverage the Download tool depending on how the documentation of the API looks like. From what I read it's just a HTTP request with a token that you need to send through the header, so it should be ok to do it.

Cheers,

brentmarion23

That is correct on what I am looking to do. I appreciate your response and help.

danilang

Hi @brentmarion23

You need to ask a specific question. Are you having trouble getting started on the process? Trouble using the download tool?

Dan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703