airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.96k stars 4.1k forks source link

Source Salesforce Commerce Cloud: vetting for a new connector #26708

Closed igrankova closed 1 year ago

igrankova commented 1 year ago

What area the feature impact?

Connectors

Revelant Information

Tell us about the problem you're trying to solve

Analyze connector documentation and answer the questions:

Describe the solution you’d like

Add the results check-list to the comments section

ycherniaiev commented 1 year ago

Webhook-based? (no/partially/yes) Partially Available authentication modes (API key/OAuth/other) JWT Access Token or OAuth Has Sandbox environment? Yes (on demand or part of Partner Program) How to populate the account with data? API or UI Available streams for sync (Streams with filters are preferable) https://developer.salesforce.com/docs/commerce/commerce-api/references/catalogs?meta=Summary assignmentsSearch POST https://{shortCode}.api.commercecloud.salesforce.com/pricing/assignments/v1/organizations/{organizationId}/assignments campaignsSearch POST https://{shortCode}.api.commercecloud.salesforce.com/pricing/campaigns/v1/organizations/{organizationId}/campaigns CATALOGS getCatalogs GET https://{shortCode}.api.commercecloud.salesforce.com/product/catalogs/v1/organizations/{organizationId}/catalogs getAssignedProductFromCategory GET https://{shortCode}.api.commercecloud.salesforce.com/product/catalogs/v1/organizations/{organizationId}/catalogs/{catalogId}/categories/{categoryId}/products/{productId} getCategorizationStatus GET https://{shortCode}.api.commercecloud.salesforce.com/product/catalogs/v1/organizations/{organizationId}/catalogs/{catalogId}/categories/{categoryId}/rules-execution getExclusionList GET https://{shortCode}.api.commercecloud.salesforce.com/product/catalogs/v1/organizations/{organizationId}/catalogs/{catalogId}/categories/{categoryId}/excluded-products https://developer.salesforce.com/docs/commerce/commerce-api/references/catalogs?meta=getCategoryRules CDN Zones: getZonesInfo GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/info getWafGroups GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/waf/groups getWafRules GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/waf/rules getFirewallRules GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/firewall/rules getSpeedSettings GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/speed-settings getSecuritySettings GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/security-settings getSecuritySettings GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/security-settings getMrtRules GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/mrtrules listLogpushJob GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/logpush/jobs getCustomRules GET https://{shortCode}.api.commercecloud.salesforce.com/cdn/zones/v1/organizations/{organizationId}/zones/{zoneId}/firewall-custom/rules COUPONS getCoupon GET https://{shortCode}.api.commercecloud.salesforce.com/pricing/coupons/v1/organizations/{organizationId}/coupons/{couponId} getCouponCodes GET https://{shortCode}.api.commercecloud.salesforce.com/pricing/coupons/v1/organizations/{organizationId}/coupons/{couponId}/codes CUSTOMERS https://developer.salesforce.com/docs/commerce/commerce-api/references/customers?meta=Summary (needs list_id - maybe no sense to implement) Gift Certificates getGiftCertificate GET https://{shortCode}.api.commercecloud.salesforce.com/pricing/gift-certificates/v1/organizations/{organizationId}/gift-certificates/{merchantId} ORDERS getOrders GET https://{shortCode}.api.commercecloud.salesforce.com/checkout/orders/v1/organizations/{organizationId}/orders PRODUCTS getProduct GET https://{shortCode}.api.commercecloud.salesforce.com/product/products/v1/organizations/{organizationId}/products/{productId} PRMOTIONS promotionsSearch POST https://{shortCode}.api.commercecloud.salesforce.com/pricing/promotions/v1/organizations/{organizationId}/promotions SHOPPER CONTEXT https://developer.salesforce.com/docs/commerce/commerce-api/references/shopper-context?meta=Summary SHOPPER EXPERIENCE getPages GET https://{shortCode}.api.commercecloud.salesforce.com/experience/shopper-experience/v1/organizations/{organizationId}/pages Integration supports incremental sync? (If there're streams with date parameters - the incremental sync could be) All the streams contain dates - so incremental syncs are possible Other information/blockers (Rate Limits: Yes/No, etc.) https://developer.salesforce.com/docs/commerce/commerce-api/guide/throttle-rates.html Rate limits more about 5-60 sec time range - no impact on Airbyte