Manoj Chaurasia Posted July 14, 2017 Share Posted July 14, 2017 I have a requirement which says, if the data in any field in the source is blank/null, the data should not be updated in the target. How can this be achieved using Scribe Online Thanks, Murali Link to comment Share on other sites More sharing options...
Jeff Levetin Posted July 14, 2017 Share Posted July 14, 2017 Hi @Murali Anand, You can achieve this in Scribe Online with: Lookup Block for the target entity This formula in the destination field in the Update block IF ( ISNULLOREMPTY (SourceEntity.field) , Taget_LookupEntity.field , SourceEntity.field) So you need to first lookup the existing record. If the source is null, write back the existing value to the field, otherwise, write the new value. Keep in mind this method will reduce performance and increase API hits for the target, as each record will require an additional lookup. There is a feature on the Scribe Online road map to perform this function without an API call and make it easier through the UI. I don't have an estimate of when it will be released. Let us know what else you need. Jeff Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted July 25, 2017 Author Share Posted July 25, 2017 Thank you so much Ben. We have implemented the same. However, i fear that this would add an additional read just for this requirement. It would be good if there is a provision to send nothing to the target when then source value is empty. Link to comment Share on other sites More sharing options...
Jeff Levetin Posted July 25, 2017 Share Posted July 25, 2017 Hi @Murali Anand, Yes, this method does add an additional read. The product manager is aware of this situation and a feature to update only when the source not empty is planned for a future release in Scribe Online. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted July 26, 2017 Author Share Posted July 26, 2017 We will eagerly await this feature! Link to comment Share on other sites More sharing options...
Niels Hwiid 2 Posted August 25, 2017 Share Posted August 25, 2017 Be aware that this do not work with Date/Time fields. When the solution read the field it will pick up 01-01-1753 00:00 as blank! Link to comment Share on other sites More sharing options...
Phil Swickard Posted August 22, 2019 Share Posted August 22, 2019 Has this been implemented Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now