Mope10 - Thread: Override Filter Format for EXA...
Thread: Override Filter Format for EXACT_DATE_RANGE
2 Replies
I am trying to override filter with EXACT_DATE_RANGE type, but the API is returning error for this.
This returns this error
is some field name wrong here? can someone help me here
curl -X POST \
--url 'https://gomotive-dev.thoughtspot.cloud/api/rest/2.0/report/liveboard' \
-H 'Content-Type: application/json' \
-H 'Authorization: Bearer <AUTH_KEY>' \
--data-raw '{
"metadata_identifier": "30dda3ee-ed2a-43cc-b500-bd1d8e0ea3bf",
"file_format": "PDF",
"override_filters": [
{
"column_name": "Combined::Date",
"date_filter": {
"op": "BW_INC",
"type": "EXACT_DATE_RANGE",
"date_range": {
"start_timestamp": "1740787200",
"end_timestamp": "1756684799"
}
},
"negate": false
}
]
}'
curl -X POST \
--url 'https://gomotive-dev.thoughtspot.cloud/api/rest/2.0/report/liveboard' \
-H 'Content-Type: application/json' \
-H 'Authorization: Bearer <AUTH_KEY>' \
--data-raw '{
"metadata_identifier": "30dda3ee-ed2a-43cc-b500-bd1d8e0ea3bf",
"file_format": "PDF",
"override_filters": [
{
"column_name": "Combined::Date",
"date_filter": {
"op": "BW_INC",
"type": "EXACT_DATE_RANGE",
"date_range": {
"start_timestamp": "1740787200",
"end_timestamp": "1756684799"
}
},
"negate": false
}
]
}'
{"message":"AxiosError: Request failed with status code 500","extensions":{"service":"CALLOSUM","upstreamResponse":{"data":"{\"error\":{\"message\":{\"code\":12723,\"incident_id_guid\":\"fe87c106-55d1-49e0-a1e3-65b8c857412c\",\"trace_id_guid\":\"tracing-disabled\",\"debug\":\"[\\\"Error in export service while generating report {\\\\\\\"stack\\\\\\\":\\\\\\\"p: failed-to-print: API error {\\\\\\\\\\\\\\\"graphQLErrors\\\\\\\\\\\\\\\":[{\\\\\\\\\\\\\\\"message\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"Invalid date filter proto type: EXACT_DATE_RANGE\\\\\\\\\\\\\\\\nop: BW_INC\\\\\\\\\\\\\\\\ndate_range {\\\\\\\\\\\\\\\\n}\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"path\\\\\\\\\\\\\\\":[\\\\\\\\\\\\\\\"Pinboard__load\\\\\\\\\\\\\\\"],\\\\\\\\\\\\\\\"extensions\\\\\\\\\\\\\\\":{\\\\\\\\\\\\\\\"service\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"BACH\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"parameters\\\\\\\\\\\\\\\":[],\\\\\\\\\\\\\\\"externalErrorMessage\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"sourceErrorDetail\\\\\\\\\\\\\\\":null,\\\\\\\\\\\\\\\"code\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"10027\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"exception\\\\\\\\\\\\\\\":{\\\\\\\\\\\\\\\"message\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"Invalid date filter proto type: EXACT_DATE_RANGE\\\\\\\\\\\\\\\\nop: BW_INC\\\\\\\\\\\\\\\\ndate_range {\\\\\\\\\\\\\\\\n}\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"service\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"BACH\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"parameters\\\\\\\\\\\\\\\":[],\\\\\\\\\\\\\\\"externalErrorMessage\\\\\\\\\\\\\\\"\\\",\\\"\\\"]\"}}}","status":500},"code":"UPSTREAM_FAILURE"}}
{"message":"AxiosError: Request failed with status code 500","extensions":{"service":"CALLOSUM","upstreamResponse":{"data":"{\"error\":{\"message\":{\"code\":12723,\"incident_id_guid\":\"fe87c106-55d1-49e0-a1e3-65b8c857412c\",\"trace_id_guid\":\"tracing-disabled\",\"debug\":\"[\\\"Error in export service while generating report {\\\\\\\"stack\\\\\\\":\\\\\\\"p: failed-to-print: API error {\\\\\\\\\\\\\\\"graphQLErrors\\\\\\\\\\\\\\\":[{\\\\\\\\\\\\\\\"message\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"Invalid date filter proto type: EXACT_DATE_RANGE\\\\\\\\\\\\\\\\nop: BW_INC\\\\\\\\\\\\\\\\ndate_range {\\\\\\\\\\\\\\\\n}\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"path\\\\\\\\\\\\\\\":[\\\\\\\\\\\\\\\"Pinboard__load\\\\\\\\\\\\\\\"],\\\\\\\\\\\\\\\"extensions\\\\\\\\\\\\\\\":{\\\\\\\\\\\\\\\"service\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"BACH\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"parameters\\\\\\\\\\\\\\\":[],\\\\\\\\\\\\\\\"externalErrorMessage\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"sourceErrorDetail\\\\\\\\\\\\\\\":null,\\\\\\\\\\\\\\\"code\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"10027\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"exception\\\\\\\\\\\\\\\":{\\\\\\\\\\\\\\\"message\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"Invalid date filter proto type: EXACT_DATE_RANGE\\\\\\\\\\\\\\\\nop: BW_INC\\\\\\\\\\\\\\\\ndate_range {\\\\\\\\\\\\\\\\n}\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"service\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\"BACH\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\"parameters\\\\\\\\\\\\\\\":[],\\\\\\\\\\\\\\\"externalErrorMessage\\\\\\\\\\\\\\\"\\\",\\\"\\\"]\"}}}","status":500},"code":"UPSTREAM_FAILURE"}}
@Mope10 can you log a bug for this