UploadDataAsync
The UploadDataAsync() function uploads data to Quintessence using a configured data feed. It processes the input range as is and bypasses any transformations.
The async functionality allows data to be uploaded automatically, without clicking Upload Sheet or Upload Selected. Uploads occur at an interval specified by the Update Resolution parameter.
Related functions: UploadData
Syntax:
Qx.UploadDataAsync(Data Feed, Update Resolution, Range, ShowError)- In Excel with Quintessence add-in versions prior to 25.1, use:
UploadDataAsync()
ⓘ See parameter descriptions
| Data Feed | The name of the data feed configured on the Quintessence server. |
| Update Resolution | The time (in seconds) between consecutive automatic uploads. |
| Range | The range of data to upload. |
| ShowError | Controls what information is returned after the data feed runs. Accepted values: • NoLog• Errors• Warnings• NoLogWarnings• NoLogErrors |
More information on ShowError:
The table below describes the output for each option, based on whether the data feed produces warnings, errors, or neither.
| ShowError Option | Warnings Only | Errors (and possibly warnings) | No Errors or Warnings |
| NoLog | TRUE | TRUE | TRUE |
| Errors | TRUE | List of errors | TRUE |
| Warnings | List of warnings | List of errors | TRUE |
| NoLogWarnings | Feed executed with warnings | Feed executed with errors/warnings | TRUE |
| NoLogErrors | TRUE | #VALUE | TRUE |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Uploading data automatically (no button clicks required)
Suppose an administrator has created a data feed called Load Prices.
The range to upload is A1:C100, you want to return only warnings (if any), and the upload should run every 60 seconds.
Formula:
=Qx.UploadDataAsync("Load Prices ", 60, A1:C100, "Warnings")There is no need to click Upload Sheet or Upload Selected in the Quintessence ribbon.
The upload will run automatically at the specified interval.