younifyd
Menu

Query Table

Read rows from a JD Edwards table or business view using the AIS Data Service

Use it in a workflow

  1. Add a step and choose the JD Edwards EnterpriseOne connector.
  2. Pick the Query Table action (under jdedwards).
  3. Fill in the fields below, then reference the result from later steps as {{queryTable.response.data}}.

Fields

targetNamestringrequired

EnterpriseOne table or business view name

targetTypestring

One oftableviewDefault "table"

filtersarray<object>

Conditions applied to the query

columnstringrequired

Qualified column name, e.g. F0101.AN8

operatorstring

One ofEQUALNOT_EQUALLESSLESS_EQUALGREATERGREATER_EQUALSTR_START_WITHSTR_END_WITHSTR_CONTAINDefault "EQUAL"

valuestringrequired
matchTypestring

One ofMATCH_ALLMATCH_ANYDefault "MATCH_ALL"

returnColumnsstring

Comma-separated qualified columns to return. Leave empty for all columns.

maxPageSizenumber

Maximum rows to return (default 100)

Default 100

forwardAllHeadersboolean

If enabled, all headers from the incoming request will be forwarded. Additional headers below will override forwarded ones.

Default false

headerskeyvalue

Extra HTTP headers to include in the request

queryParamskeyvalue

Extra URL query parameters to append to the request

Need more? See the JD Edwards EnterpriseOne guide for connection setup and behaviour shared by every action.

Was this page helpful?
Query Table — JD Edwards EnterpriseOne — Documentation