Insert/Update step not fetching table fields for existing table

Get Help & Discuss Process Studio
,
1

Hi everyone,

I am facing an issue in Process Studio while trying to dynamically handle database records.

  1. I use the Table Exists plugin to check if a specific table is available in the database.

  2. If the table exists, I route the flow to an Insert / Update step.

The Problem: When configuring the Insert / Update step, I need to define the “Keys to look up value(s)”. However, I am unable to fetch or see the Table field names in the dropdown.

2

The Insert / Update step fetches table columns from the database schema at design time. The dropdown may be empty when:

  • Target Table is blank or dynamically defined (e.g., ${TABLE_NAME}).
  • The target table does not yet exist in the database.
  • Connection or Target Schema is not configured correctly.

How to Resolve

1. Specify a Static Table (Recommended)

  • Select the correct Connection and enter/select the actual Target Table.
  • Use Get Fields / Get Update Fields to load the column mappings.
  • If required, make the table name dynamic again after configuring the mappings.

2. Enter Columns Manually

  • Type the exact database column names in the Table field column and map them to the corresponding Stream fields.

3. Ensure the Table Exists

  • If the table is created dynamically, create a sample/existing version in the development database so Process Studio can read its schema.