AnsweredAssumed Answered

400: Bad Request when testing ExactTarget upsert

Question asked by brian.richardson175446 on Jun 20, 2018
Latest reply on Jun 22, 2018 by Sjaak Overgaauw

Hello --

 

Trying to test and troubleshoot a process that reads data from SQL Server, converts to JSON with a map, then upserts to ExactTarget / Salesforce Marketing cloud. We have other processes that are upserting to the same org, so the credentials are correct. Getting Code 400: Bad Request

 

The full message I'm receiving:

 

ExactTarget: http Connector; Upsert Customer Data Operation

Failed to execute SEND operation.

log:

com.boomi.connector.ConnectorException: Error message received from Http Server, Code 400: Bad Request
at com.boomi.connector.http.BaseHttpAction.checkResponseCode(BaseHttpAction.java:673)
at com.boomi.connector.http.HttpSend.handle(HttpSend.java:377)
at com.boomi.connector.http.HttpSend.send(HttpSend.java:100)
at com.boomi.connector.custom.CustomSendConnectorAction.invoke(CustomSendConnectorAction.java:60)
at com.boomi.connector.base.BaseConnectorAction.invokeBase(BaseConnectorAction.java:364)
at com.boomi.connector.base.BaseConnectorAction.invokeWithReadStore(BaseConnectorAction.java:303)
at com.boomi.connector.base.BaseConnectorAction.invoke(BaseConnectorAction.java:275)
at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.boomi.util.ClassUtil$InvokerWithClassLoader.invoke(ClassUtil.java:369)
at com.sun.proxy.$Proxy71.invoke(Unknown Source)
at com.boomi.process.shape.ConnectorShapeHandler.execute(ConnectorShapeHandler.java:152)
at com.boomi.process.shape.ConnectorShape.execute(ConnectorShape.java:144)
at com.boomi.process.graph.ProcessShape.executeShape(ProcessShape.java:559)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:489)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:510)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:510)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:510)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:510)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:510)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:510)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:573)
at com.boomi.process.graph.ProcessGraph.execute(ProcessGraph.java:308)
at com.boomi.process.ProcessExecution.call(ProcessExecution.java:814)
at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:935)
at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:61)
at com.boomi.util.concurrent.CancellableFutureTask.run(CancellableFutureTask.java:158)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

 

Any ideas? Thanks!

Outcomes