Interface IngestionPipelineDefinition_WorkdayReportParameters_QueryKeyValue

interface IngestionPipelineDefinition_WorkdayReportParameters_QueryKeyValue {
key?: string;
value?: string;
}

Properties

key?: string

Key for the report parameter, can be a column name or other metadata

value?: string

Value for the report parameter. Possible values it can take are these sql functions:

coalesce(current_offset(), date("YYYY-MM-DD")) -> if current_offset() is null, then the passed date, else current_offset()
current_date()
date_sub(current_date(), x) -> subtract x (some non-negative integer) days from current date