UploadDataAsync
The UploadDataAsync() function uploads data to Quintessence using a configured data feed and a range of data as input. Typically, a data feed would take a file as input and apply transformations to any columns where necessary. Upload data passes a range of cells or an array to the data feed and bypasses any transformations. The async functionality allows data to be uploaded without the need to click “Upload Data” or “Upload Sheet” as it will trigger automatically as per the update resolution specified.
Syntax
UploadDataAsync (Data Feed, Update Resolution Range, ShowError)
| Data Feed | The name of the data feed on the Quintessence server |
| Update Resolution | Sets the time between consecutive uploads. This expects an amount in seconds. |
| Range | The range of Excel cells to upload. Note, this could also be an array passed as a parameter. |
| ShowError | For this function, the Show Error parameter accepts a set of options, and the output differs accordingly. The options are as follows: “NoLog”, “Errors”, “Warnings”, “NoLogWarnings”, and “NoLogErrors”. See the table below for the expected output for each option. |
| There are warnings but no errors | There are errors (and possibly warnings) | There are no errors or warnings | |
| NoLog | TRUE | The feed executed with errors/warnings | TRUE |
| Errors | TRUE | The list of errors | TRUE |
| Warnings | The list of warnings | The list of errors | TRUE |
| NoLogWarnings | The feed executed with warnings | The feed executed with errors/warnings | TRUE |
| NoLogErrors | TRUE | #VALUE | TRUE |
Example
| Function |
| UploadDataAsync(“Load MarketDataProvider1 Data”, “10”, A1:E15, “Warnings”) |