Skip to main content

Create an index on the name field

Prerequisites:

  1. Complete the tutorial setup.

  2. Create a table.

  1. Paste this code in the API API Request editor.

    {
    "api": "db",
    "action": "createIndex",
    "params": {
        "databaseName": "ctreeSQL",
        "ownerName": "admin",
        "tableName": "athlete",
        "indexName": "name",
        "fields": [
            {
                "name": "name"
            }
        ],
        "unique": false,
        "waitToBeLoaded": true
    },
    "authToken": "clickApplyDefaultsToReplaceThisWithValidAuthToken"
}

  2. Click Apply defaults to JSON request (Apply) to set the "authToken" to a valid value.

  3. Click Send request (Run Icon).

  4. Verify the action completed successfully.

    Note

    "errorCode" with a value of 0 indicates success. "errorCode" with a non-zero value indicates a failure. See Errors and contact FairCom for more information about an error.