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 :
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.
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 :
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.
