クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

Create a table API JSON Body

回答済み
デモをリクエスト

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

コメント

1件のコメント

日付 投票
  • 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

サインインしてコメントを残してください。