...
| Status Code | 200 - OK |
|---|
| Response Body | | Code Block |
|---|
{
"jobgroupId":2,
"reason":"JobStarted",
"sessionId":"24862060-4fcd-11e8-8622-fda0fbf6f550"
} |
|
|---|
Step - Publish Results to Tableau Server
The following uses the TDE results from the specified job (jobId = 2) to publish the results to the test_table3 table in the default Tableau Server database through connectionId=3.
Request:
| Endpoint | http://www.wrangle-dev.example.com:3005/v4/jobGroups/2/publish |
|---|
| Authentication | Required |
|---|
| Method | PUT |
|---|
| Request Body | | Code Block |
|---|
{
"connection": {
"id": 3
},
"path": ["default"],
"table": "test_table3",
"action": "createAndLoad",
"inputFormat": "tde",
"flowNodeId": 10
} |
|
|---|
Response:
| Status Code | 200 - OK |
|---|
| Response Body | | Code Block |
|---|
{
"jobgroupId":2,
"reason":"JobStarted",
"sessionId":"24862060-4fcd-11e8-8622-fda0fbf6f552"
} |
|
|---|
Step - Publish Results to Redshift
The following uses the Avro results from the specified job (jobId = 2) to publish the results to the test_table2 table in the public Redshift schema through connectionId=2.
| Info |
|---|
NOTE: To publish to Redshift, the targeted database is predefined in the connection object. For the path value in the request body, you must specify the schema in this database to use. Schema information is not available through API. To explore the available schemas, click the Redshift icon in the Import Data page. The schemas are the first level of listed objects. For more information, see Import Data Page. |
Request:
| Endpoint | http://www.wrangle-dev.example.com:3005/v4/jobGroups/2/publish |
|---|
| Authentication | Required |
|---|
| Method | PUT |
|---|
| Request Body | | Code Block |
|---|
{
"connection": {
"id": 2
},
"path": ["public"],
"table": "test_table2",
"action": "create",
"inputFormat": "avro",
"flowNodeId": 10
} |
|
|---|
Response:
| Status Code | 200 - OK |
|---|
| Response Body | | Code Block |
|---|
{
"jobgroupId":2,
"reason":"JobStarted",
"sessionId":"fae64760-4fc4-11e8-8cba-0987061e4e16"
} |
|
|---|
Step - Publish Results to SQL DW
The following uses the Parquet results from the specified job (jobId = 2) to publish the results to the test_table4 table in the dbo SQL DW database through connectionId=4.
Request:
| Endpoint | http://www.wrangle-dev.example.com:3005/v4/jobGroups/2/publish |
|---|
| Authentication | Required |
|---|
| Method | PUT |
|---|
| Request Body | | Code Block |
|---|
{
"connection": {
"id": 4
},
"path": ["dbo"],
"table": "test_table4",
"action": "createAndLoad",
"inputFormat": "pqt",
"flowNodeId": 10
} |
|
|---|
Response:
| Status Code | 200 - OK |
|---|
| Response Body | | Code Block |
|---|
{
"jobgroupId": 2,
"jobIds": 22,
"reason": "JobStarted",
"sessionId": "855f83a0-dc94-11e8-bd1a-f998d808020d"
} |
|
|---|
Step - Publish Results with Overrides
When you are publishing results to a relational source, you can apply overrides to the job to redirect the output or change the action applied to the target table. For more information, see API Workflow - Run Job.
