We have a requirement where Storeprocedure will execute first then we need to fetch the data from parent table then based on parent table value again we need to query to child table for getting whole records.
SP CALL => Parent Table call to get the record for child table => child Table call to get records
Currently this is working perfectly in webMethod but when we are trying to execute the same scene here in Boomi it's not working just because of session.
Current connector configuration at WebMethod end which is working for this requirment:
boomi has limited properties could you please help here to configure such thing in boomi?