sanam
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Google sheet account authorization
Hi Team, I have created Googlesheet account but every time it needs to be authorized even if I selected autorefresh. It is working for another account on other server and the only change I see is on OAuth2 Token which is not default but https://www.googleapis.com/oauth2/v3/token Can you please help how can I fix this with the new account so that I can schedule the task. Regards, Sanam2.6KViews0likes2CommentsUsing Python script with Unix snap
Hi Team, I want to run python scripts as it is running on external editor and read about unix snap can call the Python Script. Can you please let me know the steps and how can it is used to call the script. Can we upload it manually on server or do I need admin to upload it on server and is any requirement for calling external libraries?2KViews0likes1CommentRe: How to call python script in SnapLogic
igormicev: other python connectors to t Hi, Thanks for the reply I have got RPS installed but I am not able to use external lib import pyodbc from pylab import title, figure, xlabel, ylabel, xticks, bar, legend, axis, savefig from IPython.display import Math Python script error: ModuleNotFoundError(“No module named ‘pylab’”,) I need to conncet to SQL and read the data for further processing what is required to use them in the remote python script?1.3KViews0likes0CommentsHow to call python script in SnapLogic
Hi Team, I need to call below sample python script from snaplogic. or is there a way to call .py file in snaplogic import pandas as pd ################Can be snap logic pipeline###############333333 import pyodbc conn = pyodbc.connect(‘DRIVER={ODBC Driver 13 for SQL Server}; SERVER=ps-sql; database=test; trusted_connection=yes’) sql = ‘’’ select * from temp ‘’’ df = pd.read_sql(sql, conn) ######################################################33 #######################Feed SQL into python######################3 import pandas as pd longform = pd.DataFrame(columns=[‘assets__c’, ‘id’]) for idx, songs, name in df.itertuples(): name_words = (i.lower() for i in name.split()) longform = longform.append( [{‘assets__c’: nw, ‘id’: songs} for nw in name_words], ignore_index=True ) longform[‘refreshdate_unpack’] = pd.to_datetime(‘today’) longform ##############Write longform into a sql table######################9.2KViews0likes8Comments