Skip to content

config.ionbiz_Tables

The config table defines the tables that are downloaded from ionBIZ. Also, it allows adding filters, expansions, etc. to the tables.

  • Endpoint: the name of the endpoint, as defined in https://establis.ionbiz.com/odata/, e.g. Timesheets

  • Filter: the filter to apply to the table, as in OData $filter, e.g. "Date ge 2020-01-01"

  • Select: the columns to select, as in OData $select, e.g. "Date,EmployeeId,Hours"

  • Expand: the columns to expand, as in OData $expand, e.g. "Employee"

  • TypeOverwrites: the sqlalchemy types to use when creating the table, e.g. "Parent($select=Name)"

  • Active: whether the table is active or not. Inactive tables will not be downloaded.

config-ionbiz-tables-example.png