Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home Orlando Now Platform Administration Now Platform administration Data management Import sets Data sources Create a data source Create a REST (IntegrationHub) type data source

    Create a REST (IntegrationHub) type data source

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Create a REST (IntegrationHub) type data source

    Create a REST (IntegrationHub) type data source record to define what data an import set should import from a REST API.

    Before you begin

    Roles required: import_admin and action_designer

    Procedure

    1. Navigate to System Import Sets > Administration > Data Sources.
    2. Click New.
    3. Complete the form.
      Field Description
      Name A unique name for this data source.
      Import set table label A label for the import set staging table to use.
      Import set table name The Now Platform uses the label you entered to construct a unique table name. This prevents namespace collision with an already existing table.
      Type REST (IntegrationHub).
      Format The default XML-based file format (.xlsx) is supported, unless saved as "Strict Open XML Document."
      Request action Data source request action that will be invoked to get data. You can choose only published request actions.

      Click the link in the dialog box below to create/configure a new Data Source request action in IntegrationHub. After the request action is published in IntegrationHub, you can choose it as a Request action in the Data Source record. For more information, see Define action properties.

      Support pagination Selected to enable pagination for the request action. Pagination helps you reduce processing overhead by processing a specified number of records at a time, instead of processing all records at once.
      Limit Maximum number of records per page. For example, to process 50 records at a time, enter a Limit of 50.
      Offset The initial offset used for pagination. The offset is the starting record number. For example, to process 50 records at a time, starting with the first record, enter a Limit of 50 and an Offset of 0.
      Parsing script Type the script used to parse a single line of input. Three parameters are available in this function:
      • line: the current line to be parsed by the script
      • lineNumber: the line number of the current line in the entire response payload
      • result: output result
      Path for each row The path expression used to select JSON objects, which will become rows in the import set table. The path should be // for JSON objects.
      Discard Arrays Selected to discard JSON arrays as a value. Unselected to serialize JSON arrays as a value.
      Expand node children Selected if child elements of the XML node or JSON object should be converted into additional columns. Unselected if the parent column value should be an XML or JSON fragment. For JSON, note that selecting this option expands objects only, not arrays. For nested array support, see Importing JSON files.
      Data in single column Selected to store data in a single column.
      Xpath for each row XPath expression that selects the nodes which become rows in the import table. The children of the selected nodes will become the columns in the rows.
    4. Click Submit.

    What to do next

    Define a transform map for the new data source and run an import.
    • Define action properties

      Create and configure a Data Source request action in IntegrationHub. After the request action is published in IntegrationHub, you can choose it as a Request action in the Data Source record.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Create a REST (IntegrationHub) type data source

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Create a REST (IntegrationHub) type data source

      Create a REST (IntegrationHub) type data source record to define what data an import set should import from a REST API.

      Before you begin

      Roles required: import_admin and action_designer

      Procedure

      1. Navigate to System Import Sets > Administration > Data Sources.
      2. Click New.
      3. Complete the form.
        Field Description
        Name A unique name for this data source.
        Import set table label A label for the import set staging table to use.
        Import set table name The Now Platform uses the label you entered to construct a unique table name. This prevents namespace collision with an already existing table.
        Type REST (IntegrationHub).
        Format The default XML-based file format (.xlsx) is supported, unless saved as "Strict Open XML Document."
        Request action Data source request action that will be invoked to get data. You can choose only published request actions.

        Click the link in the dialog box below to create/configure a new Data Source request action in IntegrationHub. After the request action is published in IntegrationHub, you can choose it as a Request action in the Data Source record. For more information, see Define action properties.

        Support pagination Selected to enable pagination for the request action. Pagination helps you reduce processing overhead by processing a specified number of records at a time, instead of processing all records at once.
        Limit Maximum number of records per page. For example, to process 50 records at a time, enter a Limit of 50.
        Offset The initial offset used for pagination. The offset is the starting record number. For example, to process 50 records at a time, starting with the first record, enter a Limit of 50 and an Offset of 0.
        Parsing script Type the script used to parse a single line of input. Three parameters are available in this function:
        • line: the current line to be parsed by the script
        • lineNumber: the line number of the current line in the entire response payload
        • result: output result
        Path for each row The path expression used to select JSON objects, which will become rows in the import set table. The path should be // for JSON objects.
        Discard Arrays Selected to discard JSON arrays as a value. Unselected to serialize JSON arrays as a value.
        Expand node children Selected if child elements of the XML node or JSON object should be converted into additional columns. Unselected if the parent column value should be an XML or JSON fragment. For JSON, note that selecting this option expands objects only, not arrays. For nested array support, see Importing JSON files.
        Data in single column Selected to store data in a single column.
        Xpath for each row XPath expression that selects the nodes which become rows in the import table. The children of the selected nodes will become the columns in the rows.
      4. Click Submit.

      What to do next

      Define a transform map for the new data source and run an import.
      • Define action properties

        Create and configure a Data Source request action in IntegrationHub. After the request action is published in IntegrationHub, you can choose it as a Request action in the Data Source record.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login