Important Update: Archer Community Scheduled Maintenance on November 23–24 - New Community Launching Soon! Learn More..
2019-07-10 10:48 AM
Hello Team - I am looking for some help to pull the below data from one of my Archer applications in JSON API mode.
Workspace Name: Technology Control Assessments
Application Name: MY Application Repository
Data elements: Sub-Contractor-ID, Sub-Contractor-Name
I need help with a sample JSON code snippet to pull the above data elements. Appreciated your help and thanks in advance.
2019-07-10 10:59 AM
Suresh, being you already know the workspace and application name, an API call isn't needed.
For data elements, you can use this REST API call, /api/core/system/content/*content id*
You can use ODATA to filter just the fields you need.
For example:
Projecting is accomplished through the use of the OData $select keyword. This allows the caller to specify which properties of the response object should be included in the response. The following example shows a valid OData select to return only the Name and Description properties for a group domain object.
{“Value”:”?$select=Name,Description”}
Filtering is accomplished through the use of the OData $filter keyword. Logical Operators are typically used to filter the set of resources.
eq Equal
ne Not Equal
gt Greater Than
ge Greater Than or Equal
lt Less Than
le Less Than or Equal
and Logical And
or Logical Or
not Logical Negation
This following query returns all resources with id less than 100:
{“Value”:”?$filter=Id lt 100}
Advisory Consultant
2019-07-10 03:30 PM
Hi David - Thank you. I am unable to open ODATA link as it is saying Unauthorized. Please advise.
2019-07-10 03:34 PM
Sorry about that. I've update my post above on some ODATA examples.
Advisory Consultant