requests (-)

Storage of requests and its last response from the thrift API

Field name

Type

Mode

Description

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