Spark mode (Deprecated): Not supported in Spark mode.
Account:
This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See OpenAir Account for information on setting up this type of account.
Views:
Input
This Snap has exactly two document input views.
Input1: To provide the values for OpenAir read types, Search field name, Search field Value, Read type for Custom field in order to filter the data based on field names and values.
Input2: To provide the values for Date filter field name, Date filter from value, Date filter to value in order to filter the data based on date values. Only the first document is processed; a data exception error view document is created if more than one document is received.
Note: If you use the Date filter type (that is, when it is not set to [None]), it is mandatory to provide the Date filter field name value. Allowed values for Date filter field name are Created, Deleted, Updated etc. For more information, refer to OpenAir API documentation.
If you use Before filter, you must specify the Date filter to value. If you use After, Date equal to, or Date not equal to filter, you must specify the Date filter from value. If you use Between filter, you must specify the Date filter from value and Date filter to value.
Output
This Snap has at most one document output view.
Error
This Snap has at most one document error view and produces zero or more documents in the view.
Settings
Label
Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.
OpenAir read types
Required. The supported (read operation) types of the OpenAir. The types can be suggested. If a new read type is exposed in the OpenAir XML API, that can also be given.
Default value: [None]
Date filter types
The supported date filter types. Options available are:
[None]
Before
Between
After
Date equal to
Date not equal to
Default value: [None]
Include filter
The supported filter types. Options available are:
[None]
Deleted records only
Existing and deleted records.
This is used to indicate whether or not to use include filters to get deleted records. By default (NONE) will used to fetch the existing records. Default value: [None]
API Call Delay
The delay between subsequent OpenAir API calls (in milliseconds).
It is not recommended to set this property over 60000 milliseconds (1 minute).
If not specified , default behavior will be executed.
Default value: [None]
Retain null values for date
When selected, retains null values in the date field. This options is selected by default. When not selected, null values in date field are replaced with current system timestamp/date.
Example of a date with null value: <Date><hour/><minute/><timezone/><second/><month>00</month><day>00</day><year>0000</year></Date>
Default value: [None]
Do not execute if inputview1 is empty
Select this option if the Snap execution needs to be stopped when inputview1 has no records.
Default value: Not selected
Do not execute if inputview2 is empty
Select this option if the Snap execution needs to be stopped when inputview2 has no records.
Default value: Not selected
Snap Pack History
Click to view/expand
Release
Snap Pack Version
Date
Type
Updates
November 2024
main29029
Stable
Updated and certified against the current SnapLogic Platform release.
August 2024
main27765
Stable
Updated and certified against the current SnapLogic Platform release.
May 2024
main26341
Stable
Updated and certified against the current SnapLogic Platform release.
February 2024
main25112
Stable
Updated and certified against the current SnapLogic Platform release.
November 2023
main23721
Stable
Updated and certified against the current SnapLogic Platform release.
August 2023
main22460
Stable
Updated and certified against the current SnapLogic Platform release.
May 2023
main21015
Stable
Upgraded with the latest SnapLogic Platform release.
February 2023
main19844
Stable
Upgraded with the latest SnapLogic Platform release.
November 2022
main18944
Stable
Upgraded with the latest SnapLogic Platform release.
August 2022
main17386
Stable
Upgraded with the latest SnapLogic Platform release.
4.29
main15993
Stable
Upgraded with the latest SnapLogic Platform release.
4.28
main14627
Stable
Upgraded with the latest SnapLogic Platform release.
4.27
main12833
Stable
Upgraded with the latest SnapLogic Platform release.
4.26
main11181
Stable
Upgraded with the latest SnapLogic Platform release.
4.25
main9554
Stable
Upgraded with the latest SnapLogic Platform release.
4.24
main8556
Stable
Upgraded with the latest SnapLogic Platform release.
4.23
main7430
Stable
Upgraded with the latest SnapLogic Platform release.
4.22
main6403
Stable
Upgraded with the latest SnapLogic Platform release.
4.21
snapsmrc542
Stable
Upgraded with the latest SnapLogic Platform release.
4.20
snapsmrc535
Stable
Upgraded with the latest SnapLogic Platform release.
4.19 Patch
openair8336
Latest
Fixed the broken doc link for the OpenAir Write/Update Snap.
4.19
snaprsmrc528
Stable
Upgraded with the latest SnapLogic Platform release.
4.18
snapsmrc523
Stable
Upgraded with the latest SnapLogic Platform release.
4.17
ALL7402
Latest
Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.
4.17
snapsmrc515
Latest
Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.
4.16
snapsmrc508
Stable
Upgraded with the latest SnapLogic Platform release.
4.15
snapsmrc500
Stable
Upgraded with the latest SnapLogic Platform release.
4.14
snapsmrc490
Stable
Upgraded with the latest SnapLogic Platform release.
4.13
snapsmrc486
Stable
Upgraded with the latest SnapLogic Platform release.
4.12
snapsmrc480
Stable
Upgraded with the latest SnapLogic Platform release.
4.11
snapsmrc465
Stable
Upgraded with the latest SnapLogic Platform release.
4.10
snapsmrc414
Stable
Upgraded with the latest SnapLogic Platform release.
4.9
snapsmrc405
Stable
Upgraded with the latest SnapLogic Platform release.
4.8
snapsmrc398
Stable
Upgraded with the latest SnapLogic Platform release.
4.7
snapsmrc382
Stable
Upgraded with the latest SnapLogic Platform release.
4.6
rcmsf233
Stable
OpenAir Read Snap is updated with a new field to enable retention of null values in date field or replacement of null values with system timestamp/date.
Resolved an issue with OpenAir Read Snap that caused unexpected results when working with End_Date column values.
4.5.1
rcmsf231
Stable
Upgraded with the latest SnapLogic Platform release.
4.5
rcmsf231
Stable
OpenAir Read was updated with a new error condition. A data exception error view document is created if more than one document is received by input2.