|
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

Create a table API JSON Body

Besvarat
Begär demo

Hi,

I have some questions regarding the JSON body used in the "Create a table" API call.

1. "datasetUpdated": "2019-08-24T14:15:22Z", I want to use the call to set up the column structure and define data type, I am not intend to immediately import a file. Is this a required value to be entered? If it's, can I use python's datetime function to get a current time in UTC and format it to the format?

2. "hierarchyMetadata" and "metadata" in columns, the table I am creating have no such information, can I use {} or the word "None" to satisfy?

3. "uniqueTableConstraints", also if I don't have any info to provide, can I just use [] to satisfy this requirement.

For the 2 &3, I use the "Retrieve a single table" call to the table information from a table I created via UI and the returned information are shown as either None, "{}" or "[]".

0

Kommentarer

1 kommentar

Datum Röster
  • Jeff Hickey

    Hi Jase the Ace, please see TableDto type for more information about the body parameter of the Create a new table endpoint.

    At minimum, you must include "name", "tableScehma", and "type." "datasetUpdated", "hierarchyMetadata", and "uniqueTableConstraints" can be omitted. Below is sample Python request that uses the minimum body payload to create a new Data table called "Table Name" with the column "columnName" of type string (update values in italics).

    import requests
    import json

    url = "https://h.<location>.wdesk.com/s/wdata/prep/api/v1/table"

    payload = json.dumps({
      "name": "Table Name",
      "tableSchema": {
        "columns": [
          {
            "name": "columnName",
            "type": "string"
          }
        ]
      },
      "type": "data"
    })

    headers = {
      'Content-Type': 'application/json',
      'Accept': 'application/json',
      'Authorization': '<valid token>'
    }

    response = requests.request("POST", url, headers=headers, data=payload)
    print(response.text)
    0

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