HTTP Post with Token
Hi :)
Streamsets is new to me... and I'm fighting with a simple integration hehe basically what I want to do is:
- Extract data from a JDBC,
- then parse the data to an Json,
- use an HTTP to get the access token,
- remove the fields to keep only Json field and the access token
- http to load data
The step #3 is working fine and returning the token... but when ran the step #5 it fails saying:
"unable to find valid certification path to requested target"
The token that I'm giving in the step #5 is in the "header" field with the field returned from step #3.....
Thanks in advance :)
** Full message
ERROR Pipeline execution failed ProductionPipelineRunner ProductionPipelineRunnable-CDOMktCloudTrfm-CDO_MktCloud_Trfm
**com.streamsets.pipeline.api.base.OnRecordErrorException: HTTP_41 - Error sending resource. Reason: java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: **javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target****
at com.streamsets.pipeline.stage.destination.http.HttpClientTarget.processResponse(HttpClientTarget.java:269)
at com.streamsets.pipeline.stage.destination.http.HttpClientTarget.writeOneRequestPerRecord(HttpClientTarget.java:205)
at com.streamsets.pipeline.stage.destination.http.HttpClientTarget.write(HttpClientTarget.java:98)
at com.streamsets.pipeline.api.base.configurablestage.DTarget.write(DTarget.java:34)
at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:290)
at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:40)
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:235)
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:298)
at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:219)
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.processPipe(Productio
Can you please post the full stack trace showing the error message? Also, the image is broken somehow. Can you please try re-attaching it?
Sorry... just updated it.... I haven't enough points to attach an image :)
This is to post data to Market Cloud a Salesforce tool.... I'm checking with the guys here if all certificates has been added.... because I can retrieve the token... and initially it was returning error too, after add the certf, the token worked fine...