In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data becomes NULL in SQL when a workflow is ran on AYX server

TheaAbella000
7 - Meteor

Hello

 

The out data is being written to sql databse. However when the workflow is ran on server 2 of my columns become NULL when written to sql database but when i ran it locally 2 of my columns are populated in sql as it should

 

I dont know if this has something to do with the google sheets input? Is this a bug? Any idea?

3 REPLIES 3
TheaAbella000
7 - Meteor

*output data

apathetichell
19 - Altair

how do you authenticate to google sheets? Can your server authenticate to google sheets that way? IE - do you connect via username/password style combo or SAML token passed through? Your server will not have that token.

TheaAbella000
7 - Meteor

through client id and secret...do i have to reauthenticate using mine?

Labels
Top Solution Authors