requests (-)
Storage of requests and its last response from the thrift API
Field name | Type | Mode | Description |
---|---|---|---|
id | STRING | NULLABLE |
|
name | STRING | NULLABLE |
|
index | STRING | NULLABLE |
|
categories | STRING | REPEATED |
|
tags | STRING | REPEATED |
|
creationDate | STRING | NULLABLE |
|
lastModificationDate | STRING | NULLABLE |
|
thriftRequest | STRING | NULLABLE |
|
description | STRING | NULLABLE |
|
choiceId | STRING | NULLABLE |
|
variantId | STRING | NULLABLE |
|
language | STRING | NULLABLE |
|
testMode | STRING | NULLABLE |
|
queryText | STRING | NULLABLE |
|
contextItems | STRING | REPEATED |
|
contextParameters | STRING | REPEATED |
|
filters | RECORD | REPEATED |
|
filters. negative | STRING | NULLABLE |
|
filters. fieldName | STRING | NULLABLE |
|
filters. stringValues | STRING | REPEATED |
|
filters. prefix | STRING | NULLABLE |
|
filters. hierarchyId | STRING | NULLABLE |
|
filters. hierarchy | STRING | REPEATED |
|
filters. rangeFrom | STRING | NULLABLE |
|
filters. rangeFromInclusive | STRING | NULLABLE |
|
filters. rangeTo | STRING | NULLABLE |
|
filters. rangeToInclusive | STRING | NULLABLE |
|
orFilters | STRING | NULLABLE |
|
ip | STRING | NULLABLE |
|
userAgent | STRING | NULLABLE |
|
sessionId | STRING | NULLABLE |
|
profileId | STRING | NULLABLE |
|
customerId | STRING | NULLABLE |
|
connectionType | STRING | NULLABLE |
|
hitCount | STRING | NULLABLE |
|
offset | STRING | NULLABLE |
|
minHitCount | STRING | NULLABLE |
|
groupBy | STRING | NULLABLE |
|
sortFields | STRING | REPEATED |
|
returnFields | STRING | REPEATED |
|
facetRequests | STRING | REPEATED |
|
excludeVariantIds | STRING | REPEATED |
|
includeVariantIds | STRING | REPEATED |
|
scope | STRING | NULLABLE |
|
withRelaxation | STRING | NULLABLE |
|
withSemanticFiltering | STRING | NULLABLE |
|
responses | RECORD | REPEATED |
|
responses. dateTime | STRING | NULLABLE |
|
responses. results | RECORD | REPEATED |
|
responses.results. choiceId | STRING | NULLABLE |
|
responses.results. variantId | STRING | NULLABLE |
|
responses.results. scenarioId | STRING | NULLABLE |
|
responses.results. searchResult | STRING | NULLABLE |
|
responses.results. facetResponses | RECORD | REPEATED |
|
responses.results.facetResponses. name | STRING | NULLABLE |
|
responses.results.facetResponses. values | RECORD | REPEATED |
|
responses.results.facetResponses.values. label | STRING | NULLABLE |
|
responses.results.facetResponses.values. count | STRING | NULLABLE |
|
responses.results.facetResponses.values. selected | STRING | NULLABLE |
|
responses.results.facetResponses. extraInfo | RECORD | REPEATED |
|
responses.results.facetResponses.extraInfo. name | STRING | NULLABLE |
|
responses.results.facetResponses.extraInfo. value | STRING | NULLABLE |
|
responses.results. totalHitCount | STRING | NULLABLE |
|
responses.results. queryText | STRING | NULLABLE |
|
responses.results. searchResultTitle | STRING | NULLABLE |
|
responses.results. subPhrasesResults | STRING | NULLABLE |
|
responses.results. extraInfo | RECORD | REPEATED |
|
responses.results.extraInfo. name | STRING | NULLABLE |
|
responses.results.extraInfo. value | STRING | NULLABLE |
|
responses. exception | STRING | NULLABLE |
|
responses. exceptionInitialMessage | STRING | NULLABLE |
|
responses. jsonResponse | STRING | NULLABLE |
|
descriptiveData | RECORD | REPEATED |
|
descriptiveData. dateTime | STRING | NULLABLE |
|
descriptiveData. name | STRING | NULLABLE |
|
descriptiveData. color | STRING | NULLABLE |
|
descriptiveData. label | STRING | REPEATED |
|
descriptiveData. comments | RECORD | REPEATED |
|
descriptiveData.comments. language | STRING | NULLABLE |
|
descriptiveData.comments. value | STRING | NULLABLE |
|
descriptiveData. tags | STRING | REPEATED |
|
descriptiveData. categories | STRING | REPEATED |
|
descriptiveData. score | STRING | NULLABLE |
|
descriptiveData. scoreMax | STRING | NULLABLE |
|
descriptiveData. author | STRING | NULLABLE |
|
descriptiveData. icon | STRING | NULLABLE |
|
descriptiveData. attributes | STRING | NULLABLE |
|
descriptiveData. links | STRING | NULLABLE |
|
descriptiveData. refreshType | STRING | NULLABLE |
|
server | STRING | NULLABLE |
|
apiKey | STRING | NULLABLE |
|
apiSecret | STRING | NULLABLE |
|
extraction_tm | DATETIME | REQUIRED | timestamp without a timezone indicating when the records were extracted from the source table |
client_id | INTEGER | REQUIRED | ID of the client company |