Are the API endpoints working as expected? <updati...
# ask-community-for-troubleshooting
g
Are the API endpoints working as expected? updating a connector seems to get overwritten when you
reset
the connector jobs and perform a clean sync
✍️ 1
e
Hi. Can you elaborate? you are using the api to update a source and it resets the data? which source if so and please if you can provide the api call
g
• i have a mysql --> snowflake connection. • the mysql source has a table • the table has
numeric
columns • the sync fails due to normalization issues (posted issue here) • so i try to resolve this: i use the API to cast some
numeric
columns to
boolean
• i run a get request on the connector to confirm my changes. • i
reset
the connector - because it’s failed a bunch of times and i want to perform a clean sync. • after i reset the connector it starts to sync again. but i run another get request on the connector to confirm my changes are still in place. • they are not. the reset seems to have overwritten my changes via the API
actually, when you change the
Replication frequency
in the UI, it also seems to overwrite the manually set schema via the API
u
@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2521 to ensure timely resolution!
u
This is an interesting question, thanks for bringing it to our attention! I'm looking into it and hope to have some info for you later today!
e
Hi. so basically you did some changes using an update api call to the source and when you reset it removes the changes you did while using
/v1/sources/get?
if so - yea you will need to wait for airbyte team for that, since it should be fine
u
As you've raised this issue in the forum, as well as here, we are merging the two and will continue this discussion in the forum: https://discuss.airbyte.io/t/updating-schema-via-api-doesnt-persist/2776