Hi @wonka1234
You can do this by adding the following code:
Import requests
dat = Alteryx.read("#1")
Alias = dat['Fieldname'].iloc[0]
As a breakdown, ("#1") is the incoming connection you want to read from, in your example there is only one but you could have multiple inputs and read in from several.
Alias can be whatever you want to call what you're reading in, for example File, Filepath etc - this will be the name you use to refer to later on.
dat['Fieldname'] has to be the name of the field from the incoming connection that you want to get the data from.
.iloc[0] means read from the start.
A fuller example from a blog post i did recently is below so you can see how it works in full:
from ayx import Package
from ayx import Alteryx
import requests
dat = Alteryx.read("#1")
Token = dat['Token'].iloc[0]
dat = Alteryx.read("#1")
UserID = dat['UserID'].iloc[0]
dat = Alteryx.read("#2")
URL = dat['URL'].iloc[0]
dat = Alteryx.read("#3")
Filepath = dat['Filepath'].iloc[0]
dat = Alteryx.read("#4")
Filename = dat['Filename'].iloc[0]
payload = {}
files = [
('file',(Filename, open(Filepath+Filename,'rb'),'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'))
]
headers = {
'UserID' : UserID,
'Token' : Token
}
response = requests.request("POST",URL,headers=headers,data=payload, files=files)
print(response.text)
