ThingWorx Flow > Connectors Overview > System Connectors > OData > Create Association
Create Association
An association type also referred as an association is the fundamental building block for describing the relationships in the Entity Data Model (EDM). In a conceptual model, an association represents a relationship between two entity types such as a customer and an order. In an application, an instance of an association represents a specific association such as an association between an instance of a customer and an instance of an Order. Association instances are logically grouped in an association set.
An association definition contains the following information:
A unique name (required)
Two association ends, one for each entity type in the relationship (required)
An association cannot represent a relationship among more than two entity types. An association can, however, define a self-relationship by specifying the same entity type for each of its association ends.
A referential integrity constraint (optional)
Each association end must specify an association end multiplicity that indicates the number of entity type instances that can be at one end of the association. An association end multiplicity can have a value of one (1), zero or one (0..1), or many (*). Entity type instances at one end of an association can be accessed through navigation properties or foreign keys if they are exposed on an entity type.
Use this action to create an association between two entity types.
Using the Create Association Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Create Association action under the OData connector to the canvas, place the pointer on the action, and then click or double-click the action. The Create Association action window opens.
2. Edit the label name, if needed. By default, the label name is same as the action name.
3. To add a new authorization, refer to the Authorizing OData section in the OData connector topic.
If you previously added an OData authorization, select an authorization from the list.
4. In the Select Entity Set field, select an entity set.
5. In the Entity ID field, enter the entity id.
6. In the Select Association field, select the required association from the list.
7. Enter details of the selected association, and then click Done.
Output Schema
The output schema for Create Association action returns a message attribute. See a sample output schema for the Account entity set of the Create Association action for OData in the figure that follows.