Skip to main content
Solved

Data could not be updated to "Null" by CSV Inbound of FSM Connect


Ruchira Jayasinghe
Hero (Employee)
Forum|alt.badge.img+7

This customer has a requirement to update a string field with the value “NULL” via inbound integration (CSV Flat Integration).

As an example, the requirement is to send a file like the below and get it applied to the database.

When such a file is sent, the system identifies the word “NULL” as a keyword and sets the particular field empty without taking the string value NULL.

Technically, the application identifies NULL as a keyword and applies the general behavior.

 

At the same time, the customer’s required behavior can be gained from the application. The value “NULL” can be set to a field from the Smart Client.

The application identifies NULL as a string and stores it in the database.

 

The customer would like to know how the string “NULL” can be applied to the database via the integration as well.

 

Appreciate it if you could share your thoughts on this.

Best answer by ruben.maas

Hi @Ruchira Jayasinghe , 

 

This is controlled by the SetNullIdentifier, which can be configured in the Integration Settings sceen. 

The Integration settings can be found under Integration-->Integration Settings. 

Integration Settings can be managed by Dataconnector, Message Name or Type (Inbound \ Outbound). 

 

Please see sample below:

 

Cheers, 

 

Ruben

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Forum|alt.badge.img+6
  • Do Gooder (Employee)
  • March 8, 2021

Hi @Ruchira Jayasinghe ,

this looks to me like a constrain in the integration. If you cannot find the particular contrain, you can also create a update business rule which will put the value “NULL” into the field if it’s coming via a inbound message. 

Best regards,

Sven


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32

What happens if they use "" (an empty string/text) instead of "NULL"?

 


Forum|alt.badge.img+13
  • Hero (Employee)
  • March 9, 2021

Hi @Ruchira Jayasinghe , 

 

This is controlled by the SetNullIdentifier, which can be configured in the Integration Settings sceen. 

The Integration settings can be found under Integration-->Integration Settings. 

Integration Settings can be managed by Dataconnector, Message Name or Type (Inbound \ Outbound). 

 

Please see sample below:

 

Cheers, 

 

Ruben

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings