Set Shopify connector schema tables via api

[bernhard84]

Hi,

I am using the Api (POST https://api.fivetran.com/v1/connectors) to create a Shopify connector and authenticating using connect-card. I wonder if there is an option to set the schema tables via Api. I currently enable/disable tables manually after authentication is Done.

.

[James · Accepted solution]

There is - if you download the postman collection and have a look at the Modify a Connector Schema that is the request to make. 

https://fivetran.com/docs/rest-api/connectors#modifyaconnectorschemaconfig

https://fivetran.com/docs/rest-api/api-tools#fivetranpostmancollection

[bernhard84]

Another question:

In what stage can I modify the table columns for Shopify connector?

I see that after completing the flow of :

1. Create Shopify connector

2. Authenticate via connect card

Only the tables are available for modify (enable/disable), but I also need to enable or disable the columns for each table.

Is it possible only after first sync or am I missing something?

[saptarishi]

Hi, for many API based connectors, the columns structure isn't visible prior to the first sync since the columns aren't returned by the API separately.