Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Tableau Rest API - Update Data in Published Live-to-Hyper Data Sources - Server Error

stapuff106
8 - Asteroid

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-Typeapplication/json
RequestID100020

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"}}
]
}
}
]
}'

 

Tableau Docs - Update Data to Hyper 

2 REPLIES 2
MatthewO
Alteryx Alumni (Retired)

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

stapuff106
8 - Asteroid

@MatthewO I appreciate the response. I will open a ticket with Tableau.

 

Puff

Labels
Top Solution Authors