Write Null instead of Blank

By default, Connect Creatio will write a blank, "", value to the destination. If you instead want to write Null, you must use a script for this.

Function ScriptedField
  ScriptedField = "@@ORG:law_firm_c@@"
  if len(ScriptedField) = 0 then
    ScriptedField = vbNullChar
  end if
End Function

If you would prefer that no value at all gets written to the destination field, check the "Skip Blank Writes" box under Manage Stages for that stage.

Related Articles
Pull data from a source and write to file
With this map, I wanted to pull all accounts from a Sugar instance and dump a few fields into a pipe delineated file. In this map I used the same Sugar instance as both the Origin and Destination. There were no Stages created, so no action was taken ...
Creating a New Stage
Creating a Stage Under the mappings tab there is a bar titled stages. At the very end of the stages bar (on the right of the screen) there is a button with a + and what looks like a bulleted list, click this button and the New Creatio Connect Stage ...
Salesforce Connector
Additional Documentation This Connector is based on the Salesforce ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RFG/ado/ Salesforce Origin Case as Origin Table You ...
Sage 300 ERP Connector
Overview Sage 300 versions supported: 2014 and higher. It can read, write to the following tables (chart updated January 16, 2020) Sage 300 Entity Read Write Customer X X Contact 1 1 Products X Salesperson X Quote X X Order X X Invoice X X Payment ...
Queued Stages
Queued Stages are a useful feature for aggregating data or supplying "structured" data. Often systems will expect to have data bundled up and submitted all at once. A good example of this is how many ERP systems expect Sales Orders to be submitted. ...

Related Articles