Accessing the batch records in the content integration batch table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 4 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Accessing the batch records in the content integration batch table

    ServiceNow customers with thesncompliance.adminrole can access and manage batch records within thecontent integration batch tablevia theGRC: Policy and Compliance integratorapplication UI. This capability enables importing third-party compliance content into thePolicy and Compliance Managementapplication, streamlining compliance data integration and management.

    Show full answer Show less

    Key Features

    • Content Integration Batch Table: Displays batch records with key details such as batch number, content provider, state, domain, and content type. Selecting a record reveals an auto-populated form and related lists for in-depth information.
    • Compliance Staging Processor Flow: A background flow running weekly that processes batches with state Ready and content type Compliance. It automatically creates library import tasks and updates batch statuses, facilitating smooth data import.
    • REST APIs: Internal APIs allow insertion, update, retrieval, and cancellation of batch and staging records. Customers can use third-party tools like Postman to execute these APIs for automation and integration purposes.
    • Batch Processing Workflow: The process starts with using the Update batch status to ready API, which flags batches as ready for import. The Compliance staging processor flow then creates library import tasks, tracks import progress by updating batch status to In Progress, and handles provider onboarding if the content provider is not found.
    • Library Import Tasks and Staging Recommendations: These tasks are generated automatically to import staging records into Policy and Compliance Management tables. The tasks include recommendations per record and can be assigned to compliance managers for review and approval.

    Practical Application for ServiceNow Customers

    By leveraging the content integration batch table and associated flows and APIs, compliance administrators can efficiently integrate third-party compliance data into their ServiceNow GRC environment. This process automates data staging, import task creation, and status tracking, reducing manual effort and improving compliance data accuracy.

    Customers can customize the Compliance staging processor flow settings, such as scheduling, to align with their operational needs. The use of REST APIs facilitates flexible integration with external systems or automation platforms.

    Assignment of library import tasks to compliance managers ensures proper review and governance before data is imported into the Policy and Compliance Management application.

    You can access the batch records in the content integration batch table that is displayed in the GRC: Policy and Compliance integrator application UI. By accessing these records, you can import the data into the Policy and Compliance Management application.

    Overview of the content integration batch table

    As a user with the sn_compliance.admin role, you can access the batch records in the content integration batch table and create a library import task for each record. The compliance managers assignment group reviews the library import task and imports the staging records into the Policy and Compliance Management tables.

    Details of the content integration batch table

    The content integration batch table displays the details that are shown in the following example:
    • Number of the content integration batch record. In the example, CIB0001006 is the record number.
    • Provider of the content integration batch. In the example, Thomson Reuters is the provider.
    • State of the content integration batch. In the example, the state is New.
    • Domain of the content integration batch. In the example, the domain is Global.
    • Content type of the content integration batch. In the example, the type is Compliance.
    Figure 1. Content integration batch records table
    Content integration batch records table.

    To learn how you can use the user roles to access the APIs and batch records, see User roles for the integration process.

    Select a record in the table to display the content integration batch record form and its related lists. See the following example.
    Note:
    The fields in the form and the related lists are auto-populated.
    Figure 2. Content integration batch record form
    Content integration batch record form.

    Using the Compliance staging processor flow

    You can use the new Compliance staging processor flow that is provided with the GRC: Policy and Compliance integrator application. See the following example. The flow is used to process the compliance staging data and it runs in the background on a weekly basis. It searches for the content integration batch records where the state is Ready and the content type is Compliance. For each record in the content integration batch, it creates a library import task and it updates the content integration batch status automatically.
    Figure 3. Compliance staging processor flow
    Compliance staging processor flow.
    Note:
    You can update the flow to change its setting. For example, you can update the start time of the flow.

    Using the REST APIs

    You can use the REST APIs to insert the records in the GRC: integrations with third-party content and later move the records to the Policy and Compliance Management tables by using the GRC: Policy and Compliance integrator application. The following internal APIs are provided with the GRC: integrations with third-party content application and the GRC: Policy and Compliance integrator application:
    • Create batch
    • Insert policy staging records
    • Update batch status to ready
    • Get batch
    • Cancel batch
    Note:
    You can use third-party tools, such as the Postman API platform, to execute the APIs.
    When you execute the APIs in the Postman API platform as shown in the following example, the staging records are imported in the Policy and Compliance Management tables.
    Figure 4. Create a batch using the Postman API platform
    Create a batch using the Postman API platform.

    Processing the batch records

    The Update batch status to ready API and the Compliance staging processor flow process the batch records as follows:
    1. The Update batch status to ready API updates the content integration batch status to Ready as shown in the figure.
      Figure 5. Batch status Ready in the content integration batch
      Batch status Ready in the content integration batch.
    2. The Compliance staging processor flow picks up the content integration batch and its records. When the Update batch status to Ready API sets the content integration batch status to Ready, the Compliance staging processor flow acknowledges the content integration batch.

    3. When the state of the content integration batch is updated to Ready, the Compliance staging processor flow starts importing the records from staging to the GRC: Policy and Compliance integrator application.

      The system automatically creates a library import task to track the import process.

    4. When the library import task is created, the Compliance staging processor flow automatically updates the batch status to In progress.
    5. When the library import task is created and the provider that is mentioned in the content integration batch is not found, the state of the task is updated to Provider onboarding. A provider import task is created in the content onboarding task related list of the library import task.
    6. As the library import task is created, the staging recommendations for each record are generated for the content integration batch as shown in the following example.
      Figure 6. Staging recommendations
      Staging recommendations.

    The library import task is used to import the staging records in the Policy and Compliance Management tables. The library import task and staging recommendations for each record are displayed for the content integration batch table in the GRC: Policy and Compliance integrator module. A user with the sn_compliance.admin role can assign the library import task to the compliance managers assignment group. To learn how to assign a library import task, see Assign a library import task for approval.