SOAP based XML webservice with .p12 certificate and key phrase authentication

Hemachandra

Hello All,

I have a requirement to download files like .doc, .ppt. .xls and .pdf type files via SOAP based XML web service which uses .p12 certificate based authentication. I was able to successfully test the service using SOAP UI by including the ".p12" certificate file at "Keystore :" path and "Keystore password". when i tried to automate this using Alteryx designer - the download tool doesn't have this authentication mechanism.

Please let me know how can we achieve this using Alteryx designer ?

Thank you,

Hemachandra

Hemachandra

Hi Brandon,

I tried multiple methods including Zee client etc. but the simplest solution which worked for me is

1. Constructed a SOAP xml request string using "formula tool" and passed it to Python tool

2. Python tool code

import io
import requests
import pandas as pd
from ayx import Alteryx
from requests import Session

df = Alteryx.read("#1")
xml =df.iloc[0, df.columns.get_loc('xml_request')]

df = Alteryx.read("#1")
xml =df.iloc[0, df.columns.get_loc('xml_request')]

headers = {'Content-Type': 'text/xml'} # set what your server accepts
response = requests.post('https://yourendpoint.com?WSDL', data=xml, headers=headers, cert=('cert.pem','key.pem'),verify=True)

data = io.StringIO(response.text)
df2 =pd.read_csv(data, header=None)

Alteryx.write(df2,1)

3. Get the xml response out and parse the xml msg using "XML parsing tool"