Creates joins metadata

curl --request POST \
  --url http://10.2.4.166:8080/composer/api/joins/metadata \
  --header 'Authorization: Basic <encoded-value>' \
  --header 'Content-Type: application/vnd.composer.v3+json' \
  --data '
[
  {
    "sourceSchema": "<string>",
    "sourceTableName": "<string>",
    "sourceFieldName": "<string>",
    "targetSchema": "<string>",
    "targetTableName": "<string>",
    "targetFieldName": "<string>",
    "sourceConnectionId": "<string>",
    "targetConnectionId": "<string>"
  }
]
'

import requests

url = "http://10.2.4.166:8080/composer/api/joins/metadata"

payload = [
    {
        "sourceSchema": "<string>",
        "sourceTableName": "<string>",
        "sourceFieldName": "<string>",
        "targetSchema": "<string>",
        "targetTableName": "<string>",
        "targetFieldName": "<string>",
        "sourceConnectionId": "<string>",
        "targetConnectionId": "<string>"
    }
]
headers = {
    "Authorization": "Basic <encoded-value>",
    "Content-Type": "application/vnd.composer.v3+json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {
    Authorization: 'Basic <encoded-value>',
    'Content-Type': 'application/vnd.composer.v3+json'
  },
  body: JSON.stringify([
    {
      sourceSchema: '<string>',
      sourceTableName: '<string>',
      sourceFieldName: '<string>',
      targetSchema: '<string>',
      targetTableName: '<string>',
      targetFieldName: '<string>',
      sourceConnectionId: '<string>',
      targetConnectionId: '<string>'
    }
  ])
};

fetch('http://10.2.4.166:8080/composer/api/joins/metadata', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_PORT => "8080",
  CURLOPT_URL => "http://10.2.4.166:8080/composer/api/joins/metadata",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    [
        'sourceSchema' => '<string>',
        'sourceTableName' => '<string>',
        'sourceFieldName' => '<string>',
        'targetSchema' => '<string>',
        'targetTableName' => '<string>',
        'targetFieldName' => '<string>',
        'sourceConnectionId' => '<string>',
        'targetConnectionId' => '<string>'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Basic <encoded-value>",
    "Content-Type: application/vnd.composer.v3+json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "http://10.2.4.166:8080/composer/api/joins/metadata"

	payload := strings.NewReader("[\n  {\n    \"sourceSchema\": \"<string>\",\n    \"sourceTableName\": \"<string>\",\n    \"sourceFieldName\": \"<string>\",\n    \"targetSchema\": \"<string>\",\n    \"targetTableName\": \"<string>\",\n    \"targetFieldName\": \"<string>\",\n    \"sourceConnectionId\": \"<string>\",\n    \"targetConnectionId\": \"<string>\"\n  }\n]")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Basic <encoded-value>")
	req.Header.Add("Content-Type", "application/vnd.composer.v3+json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("http://10.2.4.166:8080/composer/api/joins/metadata")
  .header("Authorization", "Basic <encoded-value>")
  .header("Content-Type", "application/vnd.composer.v3+json")
  .body("[\n  {\n    \"sourceSchema\": \"<string>\",\n    \"sourceTableName\": \"<string>\",\n    \"sourceFieldName\": \"<string>\",\n    \"targetSchema\": \"<string>\",\n    \"targetTableName\": \"<string>\",\n    \"targetFieldName\": \"<string>\",\n    \"sourceConnectionId\": \"<string>\",\n    \"targetConnectionId\": \"<string>\"\n  }\n]")
  .asString();

require 'uri'
require 'net/http'

url = URI("http://10.2.4.166:8080/composer/api/joins/metadata")

http = Net::HTTP.new(url.host, url.port)

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Basic <encoded-value>'
request["Content-Type"] = 'application/vnd.composer.v3+json'
request.body = "[\n  {\n    \"sourceSchema\": \"<string>\",\n    \"sourceTableName\": \"<string>\",\n    \"sourceFieldName\": \"<string>\",\n    \"targetSchema\": \"<string>\",\n    \"targetTableName\": \"<string>\",\n    \"targetFieldName\": \"<string>\",\n    \"sourceConnectionId\": \"<string>\",\n    \"targetConnectionId\": \"<string>\"\n  }\n]"

response = http.request(request)
puts response.read_body

[
  {
    "sourceSchema": "<string>",
    "sourceTableName": "<string>",
    "sourceFieldName": "<string>",
    "targetSchema": "<string>",
    "targetTableName": "<string>",
    "targetFieldName": "<string>",
    "joinType": "INNER",
    "type": "RELATION",
    "id": "<string>",
    "sourceConnectionId": "<string>",
    "targetConnectionId": "<string>"
  }
]

{
  "error": "<string>",
  "details": "<string>",
  "message": "<string>",
  "path": "<string>",
  "status": "<string>",
  "code": "<string>",
  "errorCode": "<string>",
  "timestamp": "<string>",
  "problems": [
    {
      "name": "<string>",
      "message": "<string>",
      "level": "ERROR",
      "dependencies": {}
    }
  ]
}

{
  "timestamp": "2023-11-07T05:31:56Z",
  "status": 123,
  "error": "<string>",
  "message": "<string>",
  "path": "<string>"
}

{
  "error": "<string>",
  "details": "<string>",
  "message": "<string>",
  "path": "<string>",
  "status": "<string>",
  "code": "<string>",
  "errorCode": "<string>",
  "timestamp": "<string>",
  "problems": [
    {
      "name": "<string>",
      "message": "<string>",
      "level": "ERROR",
      "dependencies": {}
    }
  ]
}

Creates joins metadata

curl --request POST \
  --url http://10.2.4.166:8080/composer/api/joins/metadata \
  --header 'Authorization: Basic <encoded-value>' \
  --header 'Content-Type: application/vnd.composer.v3+json' \
  --data '
[
  {
    "sourceSchema": "<string>",
    "sourceTableName": "<string>",
    "sourceFieldName": "<string>",
    "targetSchema": "<string>",
    "targetTableName": "<string>",
    "targetFieldName": "<string>",
    "sourceConnectionId": "<string>",
    "targetConnectionId": "<string>"
  }
]
'

import requests

url = "http://10.2.4.166:8080/composer/api/joins/metadata"

payload = [
    {
        "sourceSchema": "<string>",
        "sourceTableName": "<string>",
        "sourceFieldName": "<string>",
        "targetSchema": "<string>",
        "targetTableName": "<string>",
        "targetFieldName": "<string>",
        "sourceConnectionId": "<string>",
        "targetConnectionId": "<string>"
    }
]
headers = {
    "Authorization": "Basic <encoded-value>",
    "Content-Type": "application/vnd.composer.v3+json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {
    Authorization: 'Basic <encoded-value>',
    'Content-Type': 'application/vnd.composer.v3+json'
  },
  body: JSON.stringify([
    {
      sourceSchema: '<string>',
      sourceTableName: '<string>',
      sourceFieldName: '<string>',
      targetSchema: '<string>',
      targetTableName: '<string>',
      targetFieldName: '<string>',
      sourceConnectionId: '<string>',
      targetConnectionId: '<string>'
    }
  ])
};

fetch('http://10.2.4.166:8080/composer/api/joins/metadata', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_PORT => "8080",
  CURLOPT_URL => "http://10.2.4.166:8080/composer/api/joins/metadata",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    [
        'sourceSchema' => '<string>',
        'sourceTableName' => '<string>',
        'sourceFieldName' => '<string>',
        'targetSchema' => '<string>',
        'targetTableName' => '<string>',
        'targetFieldName' => '<string>',
        'sourceConnectionId' => '<string>',
        'targetConnectionId' => '<string>'
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Basic <encoded-value>",
    "Content-Type: application/vnd.composer.v3+json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "http://10.2.4.166:8080/composer/api/joins/metadata"

	payload := strings.NewReader("[\n  {\n    \"sourceSchema\": \"<string>\",\n    \"sourceTableName\": \"<string>\",\n    \"sourceFieldName\": \"<string>\",\n    \"targetSchema\": \"<string>\",\n    \"targetTableName\": \"<string>\",\n    \"targetFieldName\": \"<string>\",\n    \"sourceConnectionId\": \"<string>\",\n    \"targetConnectionId\": \"<string>\"\n  }\n]")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Basic <encoded-value>")
	req.Header.Add("Content-Type", "application/vnd.composer.v3+json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("http://10.2.4.166:8080/composer/api/joins/metadata")
  .header("Authorization", "Basic <encoded-value>")
  .header("Content-Type", "application/vnd.composer.v3+json")
  .body("[\n  {\n    \"sourceSchema\": \"<string>\",\n    \"sourceTableName\": \"<string>\",\n    \"sourceFieldName\": \"<string>\",\n    \"targetSchema\": \"<string>\",\n    \"targetTableName\": \"<string>\",\n    \"targetFieldName\": \"<string>\",\n    \"sourceConnectionId\": \"<string>\",\n    \"targetConnectionId\": \"<string>\"\n  }\n]")
  .asString();

require 'uri'
require 'net/http'

url = URI("http://10.2.4.166:8080/composer/api/joins/metadata")

http = Net::HTTP.new(url.host, url.port)

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Basic <encoded-value>'
request["Content-Type"] = 'application/vnd.composer.v3+json'
request.body = "[\n  {\n    \"sourceSchema\": \"<string>\",\n    \"sourceTableName\": \"<string>\",\n    \"sourceFieldName\": \"<string>\",\n    \"targetSchema\": \"<string>\",\n    \"targetTableName\": \"<string>\",\n    \"targetFieldName\": \"<string>\",\n    \"sourceConnectionId\": \"<string>\",\n    \"targetConnectionId\": \"<string>\"\n  }\n]"

response = http.request(request)
puts response.read_body

[
  {
    "sourceSchema": "<string>",
    "sourceTableName": "<string>",
    "sourceFieldName": "<string>",
    "targetSchema": "<string>",
    "targetTableName": "<string>",
    "targetFieldName": "<string>",
    "joinType": "INNER",
    "type": "RELATION",
    "id": "<string>",
    "sourceConnectionId": "<string>",
    "targetConnectionId": "<string>"
  }
]

{
  "error": "<string>",
  "details": "<string>",
  "message": "<string>",
  "path": "<string>",
  "status": "<string>",
  "code": "<string>",
  "errorCode": "<string>",
  "timestamp": "<string>",
  "problems": [
    {
      "name": "<string>",
      "message": "<string>",
      "level": "ERROR",
      "dependencies": {}
    }
  ]
}

{
  "timestamp": "2023-11-07T05:31:56Z",
  "status": 123,
  "error": "<string>",
  "message": "<string>",
  "path": "<string>"
}

{
  "error": "<string>",
  "details": "<string>",
  "message": "<string>",
  "path": "<string>",
  "status": "<string>",
  "code": "<string>",
  "errorCode": "<string>",
  "timestamp": "<string>",
  "problems": [
    {
      "name": "<string>",
      "message": "<string>",
      "level": "ERROR",
      "dependencies": {}
    }
  ]
}

Authorizations

Authorization

string

header

required

HTTP Basic authentication using global administrator credentials (username and password).

Body

application/vnd.composer.v3+json

sourceSchema

string

required

Defines a source schema

Maximum string length: 255

sourceTableName

string

required

Defines a source table name

Maximum string length: 255

sourceFieldName

string

required

Defines a source field name

Maximum string length: 255

targetSchema

string

required

Defines a target schema

Maximum string length: 255

targetTableName

string

required

Defines a target table name

Maximum string length: 255

targetFieldName

string

required

Defines a target field name

Maximum string length: 255

joinType

enum<string>

required

Defines a join type

Available options:

INNER,

LEFT,

FULL_OUTER

type

enum<string>

required

Defines a type

Available options:

RELATION,

USER_DEFINED,

METADATA

sourceConnectionId

string

Defines a source connection identifier

targetConnectionId

string

Defines a target connection identifier

Response

The joins metadata created successfully

sourceSchema

string

required

Defines a source schema

Maximum string length: 255

sourceTableName

string

required

Defines a source table name

Maximum string length: 255

sourceFieldName

string

required

Defines a source field name

Maximum string length: 255

targetSchema

string

required

Defines a target schema

Maximum string length: 255

targetTableName

string

required

Defines a target table name

Maximum string length: 255

targetFieldName

string

required

Defines a target field name

Maximum string length: 255

joinType

enum<string>

required

Defines a join type

Available options:

INNER,

LEFT,

FULL_OUTER

type

enum<string>

required

Defines a type

Available options:

RELATION,

USER_DEFINED,

METADATA

string

read-only

Defines a join metadata identifier

sourceConnectionId

string

Defines a source connection identifier

targetConnectionId

string

Defines a target connection identifier

Release Notes

Administer

Connect to Data

Present Data

Embed and Extend

Reference

Creates joins metadata

Authorizations

Body

Response