UploadData
The UploadData() function uploads data to Quintessence using a configured data feed. It processes the input range as is and bypasses any transformations.
Related functions: UploadDataAsync
Syntax:
Qx.UploadData(Data Feed, Range, ShowError)- In Excel with Quintessence add-in versions prior to 25.1, use:
UploadData()
ⓘ See parameter descriptions
| Data Feed | The name of the data feed configured on the Quintessence server. |
| 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
Suppose an administrator has created a data feed called Load Prices.
The range to upload is A1:C100, and you want to return only warning messages (if any) when the feed runs.
Formula:
=Qx.UploadData("Load Prices", A1:C100, "Warnings")Use either the Upload Sheet or Upload Selected button in the Quintessence ribbon to execute the upload.