Attempting to delete records from a hyper file on our Tableau Server and getting the following:
Internal Server Error
The server encountered an error and cannot complete your request. Contact your server administrator.
500000
The username/password is a Site Admin with all the permissions set for projects, data sources, workbooks, etc (Super User)
Has anyone been successful in actioning a published hyper file?
Am I possibly missing something on Tableau?
Looking for thoughts on what is causing it,
Thanks,
Puff
In this scenario I am trying to delete records from OrderTest,hyper where
"Order"="4000004884" and "Line"="200"
The Download Tool configuration
Basic
1) Passing the following URL
[site url]+'api/3.17/sites/'+[site_id]+'/datasources/'+[data source id]+'/connections/'+[connection id]+'/data?uploadSessionId=100020'
Headers
2) Passing the following
Content-Type | application/json |
RequestID | 100020 |
Token from field value
Payload
HTTP Action = Custom PATCH
Passing the following as the "body"
'{
"actions":
[
{
"action": "delete",
"target-table": "OrderTest",
"condition":
{
"op": "and","args":
[
{"op": "eq", "target-col": "Order", "const": {"type": "string", "v": "4000004884"}},
{"op": "eq", "target-col": "Line", "const": {"type": "string", "v": "200"}}
]
}
}
]
}'
@stapuff106 I am not familiar with the Tableau API, however, a response in the 500 range is a server-side error. This suggests there may not be anything wrong with your request, but that an error is occurring on the Tableau Server. It may useful to contact Tableau for guidance on this error.