Forum Discussion

bavarian_bear's avatar
bavarian_bear
New Member
2 years ago

How to import data using a POST API? Specifically from Nessus Tenable endpoint

Hi all! Having the darndest time trying to get data from this API endpoint into Power BI: https://developer.tenable.com/reference/vulnerabilities-import-v2   Searched far and wide, and seems the c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

"ImportVulnerabilityData" is not the name of one of your queries. Your Source row in your "Data" query is therefore failing as it can't find a query of that name.

 

I think what you intended to do was:

let
apiKey = "accessKey=123;secretKey=321",

importedData = #"POST API"(apiKey, null),

dataTable = Table.FromList(importedData, Record.FieldValues, {})
in
dataTable

 

Also rename your function query to be a name without spaces, maybe something like fn_PostAPI.  Just makes calling it easier.