ServiceNow to Archer Integration

[mboitai2002]

Hi,

I have a requirement to integrate Servicenow with RSA Archer. I want to fetch the details from the questionnaires module and update it in ServiceNow table. This can also be done if I am fetching all the details from a report from Archer. I am trying through ServiceNow's outbound REST API msg. If anybody has tried this before, please suggest.

[Ankur Bawiskar]

@mboitai2002 

For any integration setup you need to first gather the requirements such as API endpoint, authentication details, sample request and response body

what did you start with? Did the 3rd party team shared the above details?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @mboitai2002 

https://www.servicenow.com/community/grc-forum/archer-and-servicenow-integration/m-p/1301395#M4219

[Vishal36]

Hi @mboitai2002, 

Yes, it’s possible to integrate ServiceNow with RSA Archer to pull data from the Questionnaires module or from a report and update it into a ServiceNow table. Since you're using ServiceNow’s outbound REST message, you're on the right path.

Here are a few things to keep in mind:

• Check Archer’s API access: Make sure the data you need (questionnaires or report) is available via Archer’s API, and you have the right permissions to access it.
• Handle authentication: Archer may need token-based login—ensure your REST message in ServiceNow handles that properly.
• Map the data: Understand the structure of the data coming from Archer so you can map it correctly to fields in your ServiceNow table.
• Test and handle errors: Add simple error checks so you know if something fails during the call.
• Decide how often to sync: You can schedule it or trigger it when needed, depending on how fresh you want the data to be.

If the setup becomes complex or you need something more reliable long-term, you may want to explore OpsHub Integration Manager, an enterprise–grade solution and a ServiceNow Partner. It supports this kind of integration with built-in handling for data mapping, and sync reliability—without writing a single line of code.

Hope it helps!:)

[Ajay_Chavan]

Prerequisites

Archer Side:

REST API enabled
Service account with read access to Questionnaires
Questionnaire Application ID
Field names/IDs you want to sync

ServiceNow Side:

REST Message admin access
Target table created
System properties for Archer URL/credentials
Archer REST APIs
Base URL Format:
https://[your-archer-instance]/platformapi/core/

Key APIs:
1. Authentication
POST /security/login
Body: {"InstanceName":"Default","Username":"user","Password":"pass"}
Response: SessionToken

2. Get Application Fields
GET /metadata/application/{applicationId}
Header: Authorization: Archer session-id="[token]"

3. Get Questionnaire Records
POST /content/records
Header: Authorization: Archer session-id="[token]"
Body: {"applicationId": 123, "fieldsToReturn": [1,2,3]}

4. Search Records (with filters)
POST /content/records/search
Header: Authorization: Archer session-id="[token]"
Body: {"applicationId": 123, "criteria": {...}}

5. Get Specific Record
GET /content/record/{recordId}
Header: Authorization: Archer session-id="[token]"

6. Export Report Data
GET /reports/{reportId}/data
Header: Authorization: Archer session-id="[token]"


Steps

Step 1: Setup
Create custom table in ServiceNow
Get Archer Application ID for questionnaires
Create service account in Archer

Step 2: Connection
Create REST Message in ServiceNow
Use /security/login API for authentication
Test connection

Step 3: Data Sync
Use /content/records API to fetch questionnaire data
Map Archer fields to ServiceNow table
Create scheduled job for regular sync