Export data to CSV
This section describes how to save response data as in CSV format.
The response format is determined by the “Accept” HTTP header that the
client sends in the request. By default, if no Accept header is provided, the
response format will be JSON. To get the response in CSV format, the following
header should be added to the request:
Accept: text/csv
Note
that the ASoC API uses OData V4 for filtering and selecting
the data that will be provided in the response. This also applies to responses in
CSV format.Using the API
To use the API, you must have a valid access token, and to get an access token, you need an API Key that is associated with your account. See Generating API Keys for details.
Swagger
To get the data in CSV format, simply change the default “Response Content Type” from “application/json” to “text/csv” before you click the “Execute” button.
For more details, refer to the Swagger documentation.
curl
The following is an example of a curl command that will return all the properties of
all the applications you can access from your account (replace
<access
token>
with a valid access
token):curl -X GET --header 'Accept: text/csv' --header 'Authorization: Bearer <access token>'
'https://cloud.appscan.com/api/v4/Apps'
Since the API supports OData, you
can leverage the $filter and $select request parameters to get partial data. In the
following example, only applications with High RiskRating are retrieved and each
application contains 3 properties – Id, Name and RiskRating:
curl -X GET --header 'Accept: text/csv' --header 'Authorization: Bearer <access token>'
'https://cloud.appscan.com/api/v4/Apps?
$filter=RiskRating%20eq%20'\''High'\''&$select=Id%2CName%2CRiskRating'
See also: