thumb_up
thumb_down
link
Copy link
Copied
insert_emoticon
lmatfy
Copied

Apply a filter in a GetConnector

We strongly advise that you apply a filter when you run a GetConnector. This enhances performance and gives you only the records that you need.

Example:

An environment contains a total of 100,000 ledger entries. You want to use a GetConnector to retrieve the turnover entries in the current period.

If you retrieve these ledger entries using a GetConnector without applying a filter, the result is an XML file with 100,000 records (all entries for all financial years). It takes time and capacity to generate this file and moreover, you receive many records that you do not need.

For this reason, you apply a filter by the current financial year, the current period and ledger account numbers from 8000 to 8100. This way, you only get the records that you need.

You can apply a fixed (built-in) filter or an XML filter in a GetConnector.

  • A fixed filter is built into the GetConnector and applies to every call of the GetConnector.
  • An XML filter can be different for each call and is part of the GetConnector call.

Example:

You use a GetConnector to retrieve all turnover entries from a particular financial year and a particular period.

  • Because you only ever want to retrieve turnover entries, you use a fixed filter by ledger account numbers from 8000 to 8100 for this.
  • The financial year and the period keep changing. That is why you use an XML filter for these.

Procedure

Process

Connectors

Work area

app