OpenAir Source Component is SSIS Data Flow Component for consuming data from OpenAir Service. The configuration parameters are provided in the standard data flow source component dialog.
Use the parameters below to configure the component.
Select an existing OpenAir connection manager.
Related Topics: OpenAir Connection Manager
Specify type association to initialize custom fields for it.
Specify read attributes. Multiple attributes are separated with newline, using syntax: [name]=[value]. Use attributes listed in the following table.
Attribute Value Description deleted 1 Returns deleted records. include_flags 1 Returns account or user switches, by default those are not populated. include_nondeleted 1 Returns all records, deleted and nondeleted.This attribute only works in conjunction with the deleted attribute. with_project_only 1 Used only with type: Customer. Will only return customers which have associated project records. base_currency 3 Letter currency code. Works with type: Currencyrate. Converts values on the fly to currency specified. generic 1 Returns generic resources (users) only, where by default, the API returns regular users only.
Specify the number of rows to be retrieved as a batch. Default is 1000.
Specify records filter. Multiple filters are separated with newline. Use filters listed in the following table.
Value Description open-envelopes Returns only records associated with an open envelope. approved-envelopes Returns only records associated with an approved envelope. rejected-envelopes Returns only records associated with a rejected envelope. submitted-envelopes Returns only records associated with a submitted envelope. nonreimbursed-envelopes Returns envelopes that have a non-zero balance attribute. reimbursable-envelope Returns only records associated with a reimbursable envelope. open-slips Returns only records associated with an open slip. approved-slips Returns only records associated with an approved slip. open-timesheets Returns only records associated with an open timesheet. approved-timesheets Returns only records associated with an approved timesheet. rejected-timesheets Returns only records associated with a rejected timesheet. submitted-timesheets Returns only records associated with a submitted timesheet. not-exported Returns only records that have not been marked as exported. approved-revenue-recognition-transactions Returns only revenue recognition transactions belonging to approved revenue_container records.
Date filters. Date filter parameters and multiple date filters are separated with comma. Not supported in importexport type.Example: to retrieve all records where updated field is equal or greater than Jan 1, 2011, set for filter:
date-equal-to,newer-than,updated,updated,01-01-2011,01-01-2011Example: to retrieve all records for the whole day and times use:
Specify to include custom fields in result. This property has the options listed in the following table.
Value Description True The custom fields are included in the result. False The custom fields are not included in the result (default).Deprecated in SSIS+ 1.6 SR-3. Use AssociationCustom parameter instead.
Specify to include all records in result, including the deleted. This property has the options listed in the following table.
Value Description True All records are included in the result, including the deleted. False The deleted records are not included in the result (default).Deprecated in SSIS+ 1.6 SR-3. Use Attributes parameter instead.
Select input OpenAir type.After input type change, you have to use Refresh command in the 'Column Mappings' tab to reload type metadata.
Select OpenAir retrieve method. This property has the options listed in the following table.
Value Description All Returns all available records (default). EqualTo Returns records that have fields that are equal to the field value(s) passed in MethodCriteria. Selecting this value displays the dynamic option MethodCriteria. EqualTo Returns records that have fields that are not equal to the field value(s) passed in MethodCriteria. Selecting this value displays the dynamic option MethodCriteria.
Select variable containing recordset object with method criteria(s) or specify method criteria. To match match multiple values, set field criteria to comma delimited list. To match empty value, set field criteria to empty.
The input type, filter and method criteria are available in the data flow properties list. Follow these steps to setup expression:
- Right-click on data flow canvas and select Properties menu.
- Scroll-down and find property named like [OpenAir Source].[InputType]. This is the property containing the record.
- Scroll-down and find Expressions property. Setup expression to modify the input type dynamically.
- New: A new parameter AssociationCustom. IncludeCustom parameter is deprecated.
- New: A new parameter Attributes.
- Fixed: Component failed to retrieve custom fields for Costcenter type (Thank you, Tas).
Ready to give it a try?
COZYROC SSIS+ Component Suite is free for testing in your development environment.