Skip to main content
  • EN

I have a workspace that sends data to a url through the HTTP Caller transformer. I want to terminate the workspace if a NULL value exists in a field that is in a table on a SQL database before the data is sent. What is the best way to do this? Do I still need the Creator transformer if I use a Tester?

 

You could use a Terminator after a Tester (testing for a NULL). Yes, you would still need a Creator to start things off in that case.

Thanks @liamfez, This is what I was thinking.  Would I connect the Passed Tester to the first HTTP Caller and then connect the Failed Tester to the Terminator (below)? 

 

Thanks @liamfez, This is what I was thinking.  Would I connect the Passed Tester to the first HTTP Caller and then connect the Failed Tester to the Terminator (below)? 

 

Assuming you have the Tester set up so that features that are not NULL are Passed, then yes. If a NULL feature exits the Failed port, it will then terminate translation. You can add custom messages in the Terminator to provide more information, like a short message detailing why translation was terminated, which will go to the log.


I initially misunderstood your question about the Creator. How you have that screenshot you then do not need the Creator. The reader will provide the features.

Reply


Community Stats

30,108
Posts
114,293
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.