|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Getting error 500 when trying to create a table using an API

Besvarat
Begär demo

I am using API endpoint https://h.eu.wdesk.com/s/wdata/prep/api/v1/table

Where I am trying to create a new table. 

My SCOPES in Workiva are:

data_tables|w,task:read,task:write,file:read,file:write,activity:read,data_tables|r

All I get back is the following error:

HTTPError: 500 Server Error: Internal Server Error for url: https://h.eu.wdesk.com/s/wdata/prep/api/v1/table

headers = workiva_token
table_config = WORKIVA_TABLE_SCHEMAS =
{
    "Table_1": [
        {'name': 'col_1', 'type': 'string'},
        {'name': 'col_2', 'type': 'string'},
        {'name': 'col_3', 'type': 'string'},
        {'name': 'col_4', 'type': 'string'},
        {'name': 'col_5', 'type': 'string'},
        {'name': 'col_6', 'type': 'string'},
        {'name': 'col_7', 'type': 'string'},
        {'name': 'col_8', 'type': 'string'},
        {'name': 'col_9', 'type': 'string'},
        {'name': 'col_10', 'type': 'string'},
        {'name': 'col_11', 'type': 'string'},
        {'name': 'col_12', 'type': 'string'},
        {'name': 'col_13', 'type': 'string'},
        {'name': 'col_14', 'type': 'string'},
        {'name': 'col_15', 'type': 'string'},
        {'name': 'col_16', 'type': 'string'},
        {'name': 'col_17', 'type': 'string'},
        {'name': 'col_18', 'type': 'string'},
        {'name': 'col_19', 'type': 'float'},
    ]
}
 
    response = requests.post(TABLE_ENDPOINT, headers=get_auth_headers(access_token), json=table_config, timeout=10, proxies=PROXIES)
    response.raise_for_status()
    body = response.json().get('body')

 

Could someone please advise what could be wrong?

0

Kommentarer

1 kommentar

Datum Röster
  • Jeff Hickey

    Hi Juraj Kuceravy,

    It appears your request is malformed which is the cause of the 500 error. When creating a data table, the TableDto payload at minimum needs to have a name, tableSchema property, and type. For example:

    {
      "name": "string",
      "tableSchema": {
        "columns": [
          {
            "description": "string",
            "mode": "nullable",
            "name": "string",
            "type": "string"
          }
        ]
      },
      "type": "data"
    }

    Below is an example request in Python:

    import requests
    url = "https://h.eu.wdesk.com/s/wdata/prep/api/v1/table"
    payload = {
        "name": "string",
        "tableSchema": { "columns": [
                {
                    "description": "string",
                    "mode": "nullable",
                    "name": "string",
                    "type": "string"
                }
            ] },
        "type": "data"
    }
    headers = {
        "content-type": "application/json",
        "accept": "application/json",
        "authorization": "Bearer <valid_token>"
    }
    response = requests.post(url, json=payload, headers=headers)
    print(response.json())

    For more information, please see https://developers.workiva.com/wdata-v1/wdata-createtable.html

    Thanks,
    Jeff

    0

Du måste logga in om du vill lämna en kommentar.