API Call Customer Fields

GirbanG

Greetings all,

We are trying to execute an API call to return all nodes with two custom-fields, for example, we want to list all devices that matches CF_A and CF_B. The list expected return should have the two custom fields and the corresponding IP address for each device.

"SELECT Caption, IP_ADDRESS, Comments, Department, CF_A, CF_B FROM Orion.Nodes WHERE deviceType = deviceType"

Any recommendation on the query or the best way to do this?

Thank you,

Girban

adam.beedell

Worth discussing the "api call" bit and the "SWQL query" bit separately. They can go together, but can also exist on their own.

Something like

SELECT
Caption
, IP_ADDRESS
, CF_A
, CF_B
FROM Orion.Nodes
WHERE
deviceType like deviceType
AND CF_A like 'something'
AND CF_B like 'somethingelsemaybe' 

Would be the SWQL bit based on what you're saying