MoveFields

1 Minute to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Moves fields from a source table into a new table.

Key	Value(s)	Description
method	"MoveFields"	Permanently moves fields from a source table into a new table, or can append to an existing table if record count matches exactly.
project	"activeProject"	current project name
fromTable	"SourceTableName"	Required. The source table containing fields to move.
toTable	"NewTableName"	Required. The table to recieve the moved fields. If table doesn't exist, it will be created. If table exists, the record count of the unfiltered source table must match the record count of the destination table exactly. If there is some doubt about using MoveFields to move fields into an existing table, build keys, join the tables and test the process first using CopyUp.
fields[]	[ "field1", "field2" ]	Required. The shortfieldnames of the fields to copy.
renames[]	[ "field1", "field2" ]	Optional. TODO: Need an example

Use this method to split tables. The below example will table Field1 and Field2 from the SourceTable, and use then to create a new table called NewTable.

{
  "method": "MoveFields",
  "project": "activeProject",
  "fromTable": "SourceTable",
  "toTable": "NewTable",
  "fields": [
     "Field1",
     "Field2"
   ]
}

Was this article helpful?

What's Next

RenameTable