Used resource_webhook_payload as context parameter and value assign to it -
[{
"type"
:
"application/json"
,
"data"
:
{
"vpVendorIntId"
:
6987
}},
{
"type"
:
"application/json"
,
"data"
:
{
"vpVendorIntId"
:
775
}}]
Now, I want to call this talend job using webhook call and generate JSON file. I was able to generate JSON file but the content is missing in it - {"data":[{"string":"{\"status\":\"Failed\",\"message\":\"vpVendorIntId is mandatory for getDataById API\"}","body":null,"statusCode":200}]}
When I run the process through studio then it gives the desired result - {"payload":[{"string":"{\"status\":\"Success\",\"message\":\"Done\",\"data\":{\"sessionId\":3403,\"vendorInfo\":[{\"vendorInternalNo\":\"6987\",\"vendorName\":\"ZZEH new vendor\",\"legalStructure\":\"Company\",\"vendorExternalNo\":\"ZZEH\",\"tradeName\":\"NEW TEXKF\",\"businessIdentity\":\"6669678\",\"businessIdentityType\":\"EIN\",\"vendorCategory\":\"Merchandise\",\"masterVendor\":10164,\"updatedDate\":\"2020-11-12 02:37:28.0\"}],\"vendorAddressInfo\":[{\"vendorInternalNo\":6987,\"vendorExternalNo\":\"ZZEH\",\"addressNumber\":267,\"addressName\":\"SS-XYN\",\"addressLine1\":\"20 SS NEW\",\"addressLine2\":\"SS ST\",\"city\":\"LA\",\"country\":\"United States\",\"state\":\"Louisiana\",\"zipCode\":\"67789\",\"globalLocationNo\":\"5883\",\"updatedDate\":\"2020-11-12 02:37:37.0\",\"addressType\":\"Corporate\",\"vendorReferenceNo\":null},{\"vendorInternalNo\":6987,\"vendorExternalNo\":\"ZZEH\",\"addressNumber\":24477,\"addressName\":\"SS-XYN1\",\"addressLine1\":\"20 SS NEW1\",\"addressLine2\":\"SS ST1\",\"city\":\"LA\",\"country\":\"United States\",\"state\":\"Louisiana\",\"zipCode\":\"7836\",\"globalLocationNo\":\"3573\",\"updatedDate\":\"2020-11-12 02:37:37.0\",\"addressType\":\"Corporate\",\"vendorReferenceNo\":null}],\"vendorAttributeInfo\":[{\"vendorExternalNo\":\"ZZEH\",\"attributeValue\":\"Yes\",\"vendorInternalNo\":6987,\"attributeClass\":\"TRMV\",\"attributeCode\":\"Yes\",\"updatedDate\":\"2020-11-12 02:37:45.0\"},{\"vendorExternalNo\":\"ZZEH\",\"attributeValue\":\"Delivery to DC\",\"vendorInternalNo\":6987,\"attributeClass\":\"DLYTYP\",\"attributeCode\":\"Delivery to DC\",\"updatedDate\":\"2020-11-12 02:37:45.0\"}],\"vendorBankDetailsInfo\":[{\"vendorExternalNo\":\"ZZEH\",\"commercialContractNo\":\"ZZEH CC17\",\"bankCode\":\"2570\",\"bankName\":\"SS NEW\",\"branchCode\":\"1\",\"branchName\":\"X SS LA\",\"accountNo\":\"48889989800\",\"routingNo\":\"78887\",\"accountHolderName\":\"SS\",\"bankAddress\":\"LA\",\"bankInternationCodeType\":\"IFSC\",\"bankInternationCode\":\"1\",\"vendorInternalNo\":6987,\"updatedDate\":\"2020-11-12 02:38:00.0\"},{\"vendorExternalNo\":\"ZZEH\",\"commercialContractNo\":\"ZZEH CC27\",\"bankCode\":\"2570\",\"bankName\":\"SS NEW\",\"branchCode\":\"1\",\"branchName\":\"X SS LA\",\"accountNo\":\"658970900\",\"routingNo\":\"78887\",\"accountHolderName\":\"GG\",\"bankAddress\":\"LA\",\"bankInternationCodeType\":\"IFSC\",\"bankInternationCode\":\"1\",\"vendorInternalNo\":6987,\"updatedDate\":\"2020-11-12 02:38:00.0\"}],\"vendorCommContractInfo\":[{\"vendorExternalNo\":\"ZZEH\",\"commercialContractNo\":\"ZZEH CC17\",\"commercialContractName\":\"ZZEH CC name\",\"currencyCode\":111,\"minimumOrderQty\":100,\"paymentTerms\":\"NET 30\",\"orderUOM\":\"Piece\",\"vendorInternalNo\":6987,\"updatedDate\":\"2020-11-12 02:37:41.0\",\"maximumOrderQty\":1000,\"multipleOrderQty\":5,\"shipPointName\":\"SSH\",\"vendorCommContShippoint\":408,\"paymentType\":\"ACH\"},{\"vendorExternalNo\":\"ZZEH\",\"commercialContractNo\":\"ZZEH CC27\",\"commercialContractName\":\"ZZEH CC name2\",\"currencyCode\":111,\"minimumOrderQty\":1000,\"paymentTerms\":\"NET 30\",\"orderUOM\":\"Carton\",\"vendorInternalNo\":6987,\"updatedDate\":\"2020-11-12 02:37:41.0\",\"maximumOrderQty\":10000,\"multipleOrderQty\":5,\"shipPointName\":\"SSH2\",\"vendorCommContShippoint\":409,\"paymentType\":\"Wire\"}],\"vendorContactInfo\":[{\"vendorExternalNo\":\"ZZEH\",\"contactAddressName\":\"SS-XYN\",\"contactNo\":756,\"contactName\":\"James\",\"title\":\"Mister\",\"contactFunction\":\"Sales\",\"workPhone\":\"6857075788\",\"cellPhone\":\"5423542999\",\"email\":\"cust@SS.com\",\"vendorInternalNo\":6987,\"vendorContactFaxNumber\":null,\"updatedDate\":\"2020-11-12 02:37:32.0\"},{\"vendorExternalNo\":\"ZZEH\",\"contactAddressName\":\"SS-XYN1\",\"contactNo\":757,\"contactName\":\"Sundar\",\"title\":\"Mrs\",\"contactFunction\":\"EDI CONTACT\",\"workPhone\":\"6534697400\",\"cellPhone\":\"2568768799\",\"email\":\"DG@SS.com\",\"vendorInternalNo\":6987,\"vendorContactFaxNumber\":null,\"updatedDate\":\"2020-11-12 02:37:32.0\"}],\"vendorShipPointInfo\":[{\"vendorExternalNo\":\"ZZEH\",\"vendorShipPoint\":\"409\",\"shipPointName\":\"SSH2\",\"orderToAddress\":\"SS-XYN\",\"deliveredByAddress\":\"SS-XYN\",\"invoiceByAddress\":\"SS-XYN\",\"paidToAddress\":\"SS-XYN\",\"vendorInternalNo\":6987,\"updatedDate\":\"2020-11-12 02:38:33.0\"},{\"vendorExternalNo\":\"ZZEH\",\"vendorShipPoint\":\"408\",\"shipPointName\":\"SSH\",\"orderToAddress\":\"SS-XYN\",\"deliveredByAddress\":\"SS-XYN\",\"invoiceByAddress\":\"SS-XYN\",\"paidToAddress\":\"SS-XYN\",\"vendorInternalNo\":6987,\"updatedDate\":\"2020-11-12 02:38:33.0\"}]}}","body":null,"statusCode":200}]}
Does any one know hot to solve this issue? Basically, I am looking for similar result set as above when webhook calls talend job.
