Skip to content
AutomatedOn Help Centre

See the exact query a dataset sends

The Queries tab shows the request a dataset sends to the other system. It's for reference only: nothing is run. It's useful for checking your filters, or for sharing the request with the other system's supplier or Three 17 support.

Steps

  1. Open the Queries tab

    Open the dataset on the AutomatedOn site and select Queries.

  2. Read the query

    The card shows a readable version of the query:

    • OData datasets: SELECT with each field and its AS name, FROM the entity set, and WHERE with each filter joined by AND.
    • REST datasets: SELECT, FROM GET the resource path, ITEMS the items path, WITH PARAMETERS and PAGING, which describes how further pages are fetched.

    Underneath is the full request address.

  3. Copy what you need

    Select Copy query or Copy URL. The button briefly shows Copied!. Select Refresh to rebuild the query after making changes.

More detail

Good to know

  • {aoParam:...}, $$...$$ and {aoLastRun:...} tokens are shown as written, because their values are only known when the dataset runs. {aoDynamic...} tokens are shown filled in with the current date and time.
  • No row limit is added, because the real fetch isn't limited.
  • If you see No query could be built for this dataset., the message above it explains what's missing, such as Entity Set is not set on the dataset.

Was this guide helpful?