Schema Editor

Skip to end of metadata
Go to start of metadata

 

Registration-as-a-Service (RaaS) is a premium platform that requires separate activation. If RaaS is not part of your site package, please contact Gigya by filling in a support form. You can access the support page by clicking Support on the upper menu after logging into your Gigya Console.

Description

Gigya's Schema is an integral part of our Registration-as-a-Service (RaaS) platform which allows you to add and access up to 1000 (one-thousand) additional custom fields beyond the default Profile object for each of your sites (API keys). This gives you an un-paralleled ability to customize, not only the information you store for each user, but the unique experience every user has when visiting your site.

You can use the Schema Editor of the Gigya Console to easily and interactively edit your site's schema whenever the need arises, and these new fields will be ready for use immediately.

This utility is only available to Console users that have the necessary Console permissions to use at least one of the following APIs:

If your Console user account only has permissions for accounts.getSchema, you will be able to view the current schema but all editing capabilities will be disabled.

If your account has the necessary permissions, you can locate the Schema page of the Console from the left-hand menu of the Dashboard.

 

Using The Schema Editor

Navigate to the Schema Editor of the Gigya Console.

 

Dynamic Schema

When first arriving at the Schema Editor, the data node of your site's schema will be selected and you will see the Enable dynamic schema checkbox. Dynamic schema affects the APIs you can use to create new fields in your schema.

 

  • When Dynamic Schema is disabled, you can only add new fields to your site's schema using the Schema Editor of the Gigya Console, the Screen-Sets UI Builder or the accounts.setSchema API method.
  • When Dynamic Schema is enabled, in addition to the Schema Editor and the accounts.setSchema API, you can also use the accounts.setAccountInfo API method to add new fields to your schema.

    Even when Dynamic Schema is enabled, it is recommended best practice to only create new fields in your schema via the Schema Editor, the Screen-Sets UI Builder, or the accounts.setSchema API method. Creating new fields using accounts.setAccountInfo automatically creates the field with it's write access set to serverOnly, which means that the field will only accept data from the initial user who triggered the setAccountInfo call to create the field, additional users will not be able to use this field until you manually change the write access to clientModify. If your implementation depends on new fields created with accounts.setAccountInfo, it may be adversely affected.

Editing Existing Field Properties

When you select a field from the tree in the left-hand pane of the editor, or after clicking the Create Data Field button and creating a new field, a Properties dialog will display in the right-hand pane. 

Existing fields support editing of the following properties:

  • Write Access
  • Required
  • Nullable

For an explanation of the above fields, see Adding New Fields, below.

 

Adding New Fields

To begin creating a new field, click the Create Data Field button on the top-right of the UI. Note that you can not add additional nodes beneath existing fields.

 

Next, enter a Name for the new field.

 

After entering the name, click Create and your new field will display in the left-hand tree and you will be able to configure the rest of it's properties from the right-hand panel.

 

The properties available are:

  • Name - The name of the new field in the database, this must start with the data. prefix and can only contain letters, digits, underscores "_", periods ".", begin with a letter and be a minimum of 2 characters long.

    Using periods "." in the Name field will create a nested structure, i.e.,

    data.newfield.newrow.alpha

    will create a field that corresponds to (assuming field type 'string'):

    data:{
    	newfield:{
    		newrow:{
    			alpha: ""
    		}
    	}
    }
  • Type - The type of data that you will be storing in this field, and may be:
    • integer - Any integer value from -2,147,483,648 to 2,147,483,647.
    • long - Any integer value from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
    • float - A floating point number.
    • string - Any combination of characters up to 16 KB. To search string fields with the accounts.search API , you can use partial case-insensitive search terms
    • basic-string - A string that only allows exact matching. Limited to 16K in length and allows grouping in a search query.
    • encrypted string - A value of type string that is also encrypted.
    • text - Any combination of characters up to 64 KB. To search text fields with the accounts.search API , you can only use exact match search terms.
    • date - Date values should be in the form YYYY-MM-DD.
    • boolean - Supports values of true / false.
  • Validation (regex) - A regular expression pattern that must be matched in order for the field to be submitted.
  • Write Access - Whether this field can be updated via the client-side (i.e., using Gigya's Web SDK) or only with a signed server request.
  • Required - Whether this field is required, e.g., if it is required, forms that contain this field will only submit if the field contains data. If all fields designated as required are not available on a site's Registration Completion forms, new users will be unable to complete registration. 
  • Nullable - Whether this field is allowed to accept NULL as a value.

For additional information on the above properties, please see accounts.setSchema.

Important notes:

  • Once a field is saved to the schema, it can not be deleted. It is only possible to delete fields that data has never been saved to (even if said data has been deleted) and it has not had a type defined (saving data to a field automatically assigns a  type ). You may then set it's value to null. If a field has previously had data written to it and/or has a type set, setting a field's properties to null will reset the writeAccess property to serverOnly (without deleting the field). If you think there is a scenario where you may not use a field and would like the ability to delete it, use accounts.setSchema to create the field without setting it's type.
  • Once a field is set to encrypted, it can not be un-encrypted.

 

From the Properties panel of the selected new field you can Remove Data Field if you do not want to save it, or Save Changes to the schema to make the new field permanent. You can also Refresh the schema or Discard Changes if you want to remove all unsaved changes.

 

When you are finished editing your schema, Save Changes to add all new fields to your site's schema.

 

Changed Properties

When an existing field's Properties have changed, you will see an asterisk "*" next to the corresponding field name in the left-hand tree, as well as all parent nodes. The process for saving or discarding the change are the same as described above. Note that you can not edit the Name or Type of an existing field.

 

Site Group Schema

If your site is a member of a Site Group, the only option available is to edit the Required property of existing fields, new fields can only be added to the Site Group schema via the Parent's Dashboard.

 

Additional Information

For additional information see the following resources:

 
  • No labels