Import / Export

Import Rules

Import rules are run when the data is imported from the source. The rule will change the incoming value from the data source. For example, if you have a value from a CSV file that is being imported as 0, you can transform the value using the Text Manipulation rule to change from 0 => 0.0

Example You have a value that is received from the data source as a JSON object, say

 {
   "id": 42,
   "refName" : "Material Name"
 }

You can use the

Select from Json

rule to select the key called refName from this JSON object. The value displayed onscreen will be Material Name

Example

[
{
   "id": 41,
   "refName" : "Material Name 1"
},
{
   "id": 42,
   "refName" : "Material Name 2"
 }
]

You can use the

Select from Json

rule to select the key called [1].refName from this JSON object. The value displayed onscreen will be Material Name 2. The selector [1].refName uses a text string to select the value from the array of values. In this case select the 2nd element (indexes start at 0, so element 1 is the 2nd element in the array of 2 elements), then select the refName key on the element. Nested properties are supported.

Export Rules

Export rules are run when the data is exported from SharpSync when using the Submit BOM button. The rule will change the value sent to the data source. For example, if you have value from a source, say Onshape, that was imported as 0, the displayed onscreen as 0.0, you can transform the value using the Text Manipulation rule to change from 0.0 => 0 so that the value may be accepted by Onshape.