I'm extremely new to using API's, and trying to do some basic-ish pulls using Postman for testing. The following query works perfectly in SWQL:
SELECT TOP 100 N.NodeID, N.NodeCaption, N.NodeGroup, N.AgentIP, N.MachineType, N.LastBoot, N.OSImage, N.OSVersion, N.CustomerName, C.NodeID, C.ConfigID, C.ConfigTitle, C.DownloadTime, C.AttemptedDownloadTime, C.ModifiedTime, C.ConfigType
FROM NCM.Nodes N
INNER JOIN NCM.ConfigArchive C
ON (N.NodeID = C.NodeID)
WHERE N.CustomerName LIKE 'ClientName'
ORDER BY C.DownloadTime
With 'ClientName' being an actual value. If I run the same query in Postman, I get the following response: