Previous Next JavaScript must be enabled to correctly display this content

## import

    import -table table_name -file file_name [JSON | CSV]

Imports records from the specified file into table `table_name`.

Specify a fully-qualified `table_name` as follows:

Entry specification | Description
--- | ---
`table_name` | Required. Specifies the full table name. Without further qualification, this entry indicates a table created in the default namespace (sysdefault), which you do not have to specify.
`parent-table.child-table` | Specifies a child table of a parent. Specify the parent table followed by a period (.) before the child name. For example, if the parent table is `Users`, specify the child table named `MailingAddress` as `Users.MailingAddress`.
`namespace-name:table-name` | Specifies a table created in the non-default namespace. Use the namespace followed by a colon (:). For example, to reference table `Users`, created in the `Sales` namespace, enter table_name as `Sales:Users`.

Use `-table` to specify the name of a table into which the records are loaded. The alternative way to specify the table is to add the table specification "Table: `table_name`" before its records in the file.

For example, this file contains the records to insert into two tables, `users` and `email`:

    Table: users
    <records of users>
    ...
    Table: emails
    <record of emails>
    ...

The imported records can be either in JSON or CSV format. If you do not specify the format, JSON is assumed.