topic [resolved] JSON Payload - Validate in Talend Studio

[resolved] JSON Payload - Validate

root — Sat, 16 Nov 2024 10:25:26 GMT

I have a simple webservice setup.

tRestRequest --> tExtractJSONFields --> my processing code --> tXMLMap --> tRestResponse

It works perfectly fine. However, one missing chunk is how to validate the input JSON payload (POST in my case) and send back an error HTTP code like 400 back to the client?

Is there any direct way to validate the JSON document being sent which has all the relevant fields? What are the best practices which one can follow to design the job?

Re: [resolved] JSON Payload - Validate

Anonymous — Wed, 31 Aug 2016 13:36:59 GMT

Hi
Here is my idea: validate all of fields on a tJavaRow and then trigger different processing based on the validation result, eg:
tRestRequest --> tExtractJSONFields -->main--tJavaRow--runIf1---tfixedFlowInput--main--my processing code...tRestResponse1
--runIf2---tfixedFlowInput--main--tXMLMap--...tRestResponse2

on tJavaRow:
if(..multiple validation condition..){
global.put("isValid",true);
context.columnName=input_row.columName;
context.otherColumnName=input_row.otherColumnName;
}else{
global.put("isValid",false);
}

set the condition of runIf1 as:
(Boolean)globalMap.get("isValid")

set the condition of runIf2 as:
!(Boolean)globalMap.get("isValid")

tfixedFlowInput: generate the current row with context variables.

Regards
Shong

Re: [resolved] JSON Payload - Validate

root — Wed, 31 Aug 2016 20:36:57 GMT

shong wrote:
Hi
Here is my idea: validate all of fields on a tJavaRow and then trigger different processing based on the validation result, eg:
tRestRequest --> tExtractJSONFields -->main--tJavaRow--runIf1---tfixedFlowInput--main--my processing code...tRestResponse1
--runIf2---tfixedFlowInput--main--tXMLMap--...tRestResponse2

on tJavaRow:
if(..multiple validation condition..){
global.put("isValid",true);
context.columnName=input_row.columName;
context.otherColumnName=input_row.otherColumnName;
}else{
global.put("isValid",false);
}

set the condition of runIf1 as:
(Boolean)globalMap.get("isValid")

set the condition of runIf2 as:
!(Boolean)globalMap.get("isValid")

tfixedFlowInput: generate the current row with context variables.

Regards
Shong

This is great. I tried, it works. I was actually expecting a way in which a JSON document could be validated directly on a schema or something... but, again, this works. Thanks.