Rahul Padhy
05/27/2021, 10:10 AMSubodh (Airbyte)
Rahul Padhy
05/27/2021, 10:20 AMSubodh (Airbyte)
Rahul Padhy
05/27/2021, 10:21 AMChris (deprecated profile)
"operationsIds" : []
instead of empty stringsRahul Padhy
05/27/2021, 10:23 AMChris (deprecated profile)
Rahul Padhy
05/27/2021, 10:25 AMChris (deprecated profile)
cursorField
, primaryKey
etcRahul Padhy
05/27/2021, 10:27 AMChris (deprecated profile)
Rahul Padhy
05/27/2021, 10:29 AMChris (deprecated profile)
Rahul Padhy
05/27/2021, 10:32 AMSubodh (Airbyte)
operationsIds
and using empty array (without empty string) for fields like cursorField
Rahul Padhy
05/27/2021, 10:35 AMSubodh (Airbyte)
operationsIds
and do not use empty string in array for other filedsRahul Padhy
05/27/2021, 10:38 AMStatus code : 200
{
"connectionId": "8c456147-405c-4079-a292-be1d84a6b77d",
"name": "default",
"prefix": "",
"sourceId": "61952097-5cea-46bd-96f8-90fc4cd2290e",
"destinationId": "c89a4973-2bfd-4273-a72d-58754549cae2",
"syncCatalog": {
"streams": [
{
"stream": {
"name": "api_oppo_hist",
"jsonSchema": {
"$schema": "<http://json-schema.org/draft-07/schema#>",
"type": "object",
"properties": {
"ACV": {
"type": "number"
},
"CS Revenue": {
"type": "number"
},
"CVR SQL to Customer": {
"type": "number"
},
"CVR from MQL to SQL": {
"type": "number"
},
"Churn ARR": {
"type": "number"
},
"Churned Customers": {
"type": "number"
},
"Closed Date": {
"type": "string"
},
"Id": {
"type": "number"
},
"Invoiced Revenue": {
"type": "number"
},
"MQL BDR": {
"type": "number"
},
"MQL Marketing": {
"type": "number"
},
"MQL Marketing - Adwords": {
"type": "number"
},
"MQL Marketing - Digital": {
"type": "number"
},
"MQL Marketing - Events, Roundtable & Webinars": {
"type": "number"
},
"MQL Marketing - X": {
"type": "number"
},
"MQL Partnerships": {
"type": "number"
},
"New ARR": {
"type": "number"
},
"Number of MQL": {
"type": "number"
},
"Number of New Customers": {
"type": "number"
},
"Number of SQL": {
"type": "number"
},
"Old ARR to go Live": {
"type": "number"
},
"Region": {
"type": "string"
},
"Renewal": {
"type": "number"
},
"Sales Driven Expansion Revenue": {
"type": "number"
},
"Total ARR": {
"type": "number"
},
"Total Customer": {
"type": "number"
},
"Usage expansion": {
"type": "number"
},
"__sdc_row": {
"type": "number"
},
"__sdc_sheet_id": {
"type": "number"
},
"__sdc_spreadsheet_id": {
"type": "string"
},
"_sdc_batched_at": {
"type": "string"
},
"_sdc_extracted_at": {
"type": "string"
},
"_sdc_received_at": {
"type": "string"
},
"_sdc_sequence": {
"type": "number"
},
"_sdc_table_version": {
"type": "number"
}
}
},
"supportedSyncModes": [
"full_refresh"
],
"sourceDefinedCursor": false,
"defaultCursorField": [
""
],
"sourceDefinedPrimaryKey": [
[
""
]
],
"namespace": ""
},
"config": {
"syncMode": "full_refresh",
"cursorField": [
""
],
"destinationSyncMode": "overwrite",
"primaryKey": [
[
""
]
],
"aliasName": "api_oppo_hist",
"selected": true
}
}
]
},
"schedule": {
"units": 24,
"timeUnit": "hours"
},
"status": "active"
}
Subodh (Airbyte)
[""]
) for fields like primaryKey
in your post request?Rahul Padhy
05/27/2021, 10:45 AMSubodh (Airbyte)
[]
)Rahul Padhy
05/27/2021, 10:46 AMSubodh (Airbyte)
Rahul Padhy
05/27/2021, 10:50 AMChris (deprecated profile)
[]
is probably preferableRahul Padhy
05/27/2021, 10:51 AMSubodh (Airbyte)
primaryKey
you use 2-D arrays. for cursorField
you use 1-D. Refer to the example in the doc https://airbyte-public-api-docs.s3.us-east-2.amazonaws.com/rapidoc-api-docs.html#post-/v1/connections/createRahul Padhy
05/27/2021, 10:54 AMStatus code : 200
{
“connectionId”: “dabb363f-1d6f-4ee7-90d2-f97d1d15762f”,
“name”: “default”,
“prefix”: “”,
“sourceId”: “61952097-5cea-46bd-96f8-90fc4cd2290e”,
“destinationId”: “c89a4973-2bfd-4273-a72d-58754549cae2",
“syncCatalog”: {
“streams”: [
{
“stream”: {
“name”: “api_oppo_hist”,
“jsonSchema”: {
“$schema”: “<http://json-schema.org/draft-07/schema#>”,
“type”: “object”,
“properties”: {
“ACV”: {
“type”: “number”
},
“CS Revenue”: {
“type”: “number”
},
“CVR SQL to Customer”: {
“type”: “number”
},
“CVR from MQL to SQL”: {
“type”: “number”
},
“Churn ARR”: {
“type”: “number”
},
“Churned Customers”: {
“type”: “number”
},
“Closed Date”: {
“type”: “string”
},
“Id”: {
“type”: “number”
},
“Invoiced Revenue”: {
“type”: “number”
},
“MQL BDR”: {
“type”: “number”
},
“MQL Marketing”: {
“type”: “number”
},
“MQL Marketing - Adwords”: {
“type”: “number”
},
“MQL Marketing - Digital”: {
“type”: “number”
},
“MQL Marketing - Events, Roundtable & Webinars”: {
“type”: “number”
},
“MQL Marketing - X”: {
“type”: “number”
},
“MQL Partnerships”: {
“type”: “number”
},
“New ARR”: {
“type”: “number”
},
“Number of MQL”: {
“type”: “number”
},
“Number of New Customers”: {
“type”: “number”
},
“Number of SQL”: {
“type”: “number”
},
“Old ARR to go Live”: {
“type”: “number”
},
“Region”: {
“type”: “string”
},
“Renewal”: {
“type”: “number”
},
“Sales Driven Expansion Revenue”: {
“type”: “number”
},
“Total ARR”: {
“type”: “number”
},
“Total Customer”: {
“type”: “number”
},
“Usage expansion”: {
“type”: “number”
},
“__sdc_row”: {
“type”: “number”
},
“__sdc_sheet_id”: {
“type”: “number”
},
“__sdc_spreadsheet_id”: {
“type”: “string”
},
“_sdc_batched_at”: {
“type”: “string”
},
“_sdc_extracted_at”: {
“type”: “string”
},
“_sdc_received_at”: {
“type”: “string”
},
“_sdc_sequence”: {
“type”: “number”
},
“_sdc_table_version”: {
“type”: “number”
}
}
},
“supportedSyncModes”: [
“full_refresh”
],
“sourceDefinedCursor”: false,
“defaultCursorField”: [],
“sourceDefinedPrimaryKey”: [
[]
],
“namespace”: “”
},
“config”: {
“syncMode”: “full_refresh”,
“cursorField”: [],
“destinationSyncMode”: “overwrite”,
“primaryKey”: [
[]
],
“aliasName”: “api_oppo_hist”,
“selected”: true
}
}
]
},
“schedule”: {
“units”: 24,
“timeUnit”: “hours”
},
“status”: “active”
}
Chris (deprecated profile)
Rahul Padhy
05/27/2021, 11:30 AMSubodh (Airbyte)
Rahul Padhy
05/27/2021, 3:36 PMSubodh (Airbyte)
Rahul Padhy
05/27/2021, 3:38 PMSubodh (Airbyte)
Rahul Padhy
05/27/2021, 3:42 PMSubodh (Airbyte)
Rahul Padhy
05/28/2021, 3:58 PMSubodh (Airbyte)
Rahul Padhy
05/31/2021, 6:41 AMSunil Kumar B
06/24/2021, 1:42 PMtakan
06/28/2021, 9:39 AMSubodh (Airbyte)