|
Klassieke bestandstypen zijn vanaf januari 2021 niet meer beschikbaar voor gebruik. U kunt uw klassieke bestanden omzetten of een PDF downloaden. Meer informatie

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

Beantwoord
Demo aanvragen

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

Opmerkingen

1 opmerking

Datum Stemmen
  • 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

U moet u aanmelden om een opmerking te plaatsen.