Hi Experts,
I’m trying to create a csv export that gives the list of LINUX sources. Currently we have 600+ sources, among that 200 are Linux. Now I want to export only Linux sources.
Could someone please share the search query to be used in API to get this required csv.
IDN’s search interface does not support the searching of sources. You will have to use the API to achieve this. The list sources API provides several filters that can be used to narrow down the search results to just Linux sources. Which filters you use will depend on how your Linux sources are named. For example, if the names of your Linux sources all contain the word “Linux” somewhere in the name then you can use the following query (ex. “Employees - Linux”, “Linux - CRM”, “First Linux Source” etc). This operation is case insensitive, so capital letters don’t matter.
GET https://{tenant}.api.identitynow.com/v3/sources?filters=name co "linux"
Our APIs return JSON data, so if you need this in CSV format, you will have to use a tool or write a script to convert the JSON output to CSV. Just Google “JSON to CSV” for an idea of how to do this.
@colin_mckibben Thanks for the quick reply.
using the query shared, i can get the list of Linux sources, But it gives me all the attributes of the connector such as attached image. But I need only few attributes from that. Is there any filters I can use to pick the fields or attributes I want from the Source.
At this time, it is not possible to limit which fields are returned from the API. However, you can write a script to do some post-processing of the JSON data returned to create a report that contains just the fields you want.