Use a PDF to create data tables

PDF parsing limitations

The following limitations currently exist when uploading a PDF using this tool:

• PDF cannot be converted from an image.
• PDF cannot be longer than 25 pages.
• PDF file size cannot exceed 5 MB.
• Languages other than English and French are not currently supported.

Parent Topic:Create a data model for your application

Create a table from a PDF form

Add data tables to your application by uploading a PDF in App Engine Studio.

Before you begin

Note: This feature is only available if your licensing entitles you to "exclusive low code capability" and you have Table Builder for App Engine installed. Contact your Solutions consultant for more information.

Verify that the PDF meets the following requirements:

• PDF cannot be converted from an image.
• PDF cannot be longer than 25 pages.
• PDF file size cannot exceed 5 MB.
• Languages other than English and French are not currently supported.

Role required: admin, sn_app_eng_studio.user, or delegated_developer

Procedure

1. Navigate to All > App Engine > App Engine Studio.

2. From the My Apps page, open your application.

3. Next to the Data heading, select the Add icon (

1. Select Create a blank table, and then select Continue.

2. Select Upload a PDF and then select Continue.

3. Select and upload the PDF.

   You can drag the PDF file onto App Engine Studio or browse your computer.

   Note: It may take a moment for the PDF to load. Select the trash icon (

1. Select Continue.

   Note: It may take up to a minute for the PDF to be parsed.

2. Define the properties for your new table.

1. Select Continue.

   You may now configure permissions for your new data table.

2. Control who has access to create, read, write, and delete content from this table by adding new roles and/or defining the desired Create, Read, Write, Delete permissions for existing roles.

   Roles that you create in the table persist throughout the application and can be further defined in other tables you add. See Add application security for more information on how security permissions work.

   Note: At least one role must have read access for you to be able to preview the table.

3. Select Continue after you have configured table permissions.

4. Select Go to PDF extractor to open up the PDF in the PDF extractor.

What to do next

Next, you will add fields from the uploaded PDF. Follow the steps in Add new fields from a PDF form to populate your new data table with field columns.

Add new fields from a PDF form

Add field columns to your data table using the PDF extractor in App Engine Studio.

Before you begin

Note: This feature is only available if your licensing entitles you to "exclusive low code capability" and you have Table Builder for App Engine installed. Contact your Solutions consultant for more information.

Role required: admin, sn_app_eng_studio.user, or delegated_developer

Procedure

1. Choose one of the following options:

   • Follow the steps outlined in the previous procedure to upload a PDF (see Create a table from a PDF form).
   • If you have already uploaded the PDF, select the Open pdf extractor element on the Forms or Table tab in Table Builder to launch the PDF extractor tool. The PDF form displays.

2. Review the PDF.

   Use any of the navigational controls in the PDF pane to navigate to where you'd like to begin adding fields. See General navigation.

3. Click Select to enter text selection mode.

4. In the PDF, click on a field or text phrase to highlight it to use it as the basis for a new field.

1. Edit the extracted text in the Field Label as needed for the new field you are going to add.

2. Choose a Field type.

   Field type refers to the type of data that the new column will store. For example, to store plain text in the column, select String. To understand the basic field properties, see Add and customize a field in a table.

   Depending on the type that you select, you may need to fill in additional fields to further define the table column. For example, with Reference field types, search for and select the appropriate data table to reference.

   1. If you have chosen to create a choice field, perform the following actions to populate options for the choice field.

      1. Choose a Choice Type from the menu. This controls whether or not the list will have None as an option.
      2. Click in the Choices field, and then enter text manually or select text on the PDF to automatically extract it.
      3. Click Add to add your choice to the list.

2.  Repeat the previous steps until all choices have been added for your choice field.

1. Select the Table where you want to add the new field.

   Multiple options may appear if you have added reference tables. The original table is selected by default.

2. Select Add field to add the field to the list of fields in the table on the right.

   Note: Any fields you add to the table on the right remain highlighted in green in the PDF to remind you that you have created a related field from them. If you delete a field from the tables on the right, the extracted text will no longer be highlighted.

3. Repeat the steps above until you have added all the fields you want to add from the PDF.

   Note: You can also add fields manually by clicking +Add new field in the table on the right and entering details directly similar to how you add fields on the Table tab of Table Builder.

4. Review the fields in your table and edit as necessary.

1. Select Save.

What to do next

To open your data table in Table Builder, select Open data table and form above the displayed tables. For more information on editing your data tables in Table Builder, see Table Builder.

To add a reference table, see Add a reference table from a PDF form.

Add a reference table from a PDF form

Move fields into a new referenced data table using the PDF extractor in App Engine Studio.

Before you begin

Note: This feature is only available if your licensing entitles you to "exclusive low code capability" and you have Table Builder for App Engine installed. Contact your Solutions consultant for more information.

Role required: admin, sn_app_eng_studio.user, or delegated_developer

About this task

You may decide that you want to add some of the form information into separate tables that are referenced from the original table and can be referenced by other tables. For example, if you work for an insurance company, you may want to create separate data tables for bills, claims, and policies that can be referenced as separate data tables even though the information is extracted from a single PDF form.

You can add a reference field, and then create the corresponding reference data table directly from the PDF extractor in App Engine Studio.

Note: Before you create any new reference tables for your app, it's a good practice to verify that you are not accidentally recreating any tables that already exist on the ServiceNow AI Platform.

Procedure

1. Choose one of the following options:

   • Follow the steps outlined in the previous procedure to upload a PDF (see Create a table from a PDF form).
   • If you have already uploaded the PDF, select the Open pdf extractor element on the Forms or Table tab in Table Builder to launch the PDF extractor tool. The PDF form displays.

2. Select Add reference table in the right side panel to add a reference table to your table.

3. Enter the following properties for your reference table.

   Column header property	Description
   Table label	Unique label for the reference table.
   Table name	Database name for the reference table.
   Make extensible	Option to allow other tables to share data from this table. For more information on table extension, see Table extension.
   Auto number	Option to track table records with a unique number. If you select this option, define the Prefix, Starting number, and Number of digits.

   Next, you will add a reference field to the original table you are editing. This creates the connection between the tables (e.g., "Seller info").

4. Select the Table label of the table where you want to add your reference field in (the original table is selected by default).

   The original table should be selected by default in the Table label field.

5. Enter a Reference field label for this new reference field (e.g., "Seller information").

6. Select fields from your original table to add them to your new reference table.

   These fields are related to the reference field you added to the current table.

1. Select Add reference table.

   The reference table appears below and contains the fields that you selected that were in the original table.

2. Review and edit the fields and table properties as necessary.

See [General navigation](pdf-extractor.md) for more information on additional navigational controls in the table pane.

1. Select Save.

What to do next

To open your data table in Table Builder, select Open data table and form above the displayed tables. For more information on editing your data tables in Table Builder, see Table Builder.