Solved

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

  • 8 March 2021
  • 3 replies
  • 176 views

Userlevel 5
Badge +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.

icon

Best answer by ruben.maas 9 March 2021, 09:26

View original

This topic has been closed for comments

3 replies

Userlevel 3
Badge +6

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

Userlevel 7
Badge +30

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

 

Userlevel 5
Badge +13

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