Hello ThoughtSpot Support,

Hello ThoughtSpot Support,

I am encountering an issue with the ThoughtSpot API regarding the retrieval of precise dates in datetime format. Currently, the dates are returned as Unix timestamps, which complicates their manipulation and display in a readable format. Additionally, the dates are automatically rounded to the beginning of the month, which skews the data.

Query :

https://###/callosum/v1/tspublic/v1/searchdata?query_string=[Person ID][day(Birth Date)][month(Birth Date)][date(Birth Date)][Birth Date][Count for Active Members]>"0"[LoadYearMonth]="june 2024"&data_source_guid=###&pagenumber=1&batchsize=100&formattype=FULL

https://###/callosum/v1/tspublic/v1/searchdata?query_string=[Person ID][day(Birth Date)][month(Birth Date)][date(Birth Date)][Birth Date][Count for Active Members]>"0"[LoadYearMonth]="june 2024"&data_source_guid=###&pagenumber=1&batchsize=100&formattype=FULL

Example Response:

json

[
{
"Person ID": 12345,
"Birth Date": {
"v": {
"s": 930787200
}
},
"Registration Date": {
"v": {
"s": 1706745600
}
}
},
...
]

Can you help me resolve this issue? Is there a specific configuration in the API or a method to obtain correctly formatted dates directly via the ThoughtSpot API, without rounding to the beginning of the month?

Thank you for your help.

shikharTS•6/18/24, 11:41 PM

Epoch is the standard date format used across TS APIs. Also if we have aggregation for the month, the date will automatically be rounded to the beginning of month since that is less ambiguous. Do you want the exact date without aggregation? Maybe after retrieval you can change the dates using your own library functions? You can try to use the formulas provided in TS to maybe change the dates to not come as beginning of the month..