Powershell command using tSystem

Six Stars

Powershell command using tSystem

Hi,
Can you please guide me on the issue.
I need to upload a file to a site. I am using ySystem component to run the powershell.
I get escape character error. I am not able to resolve it.

Below is my command:

 

"cmd /c start powershell -noninteractive C:\\Curl_windows\\src\\curl.exe -H 'X-API-TOKEN:ZLQuFZWY5zekZd' -F 'surveyId=SV_8dpoD2nJ3' -F 'file=@C:\\Logs\\surveyresponseimport.csv;type=text/csv' 'https:\/\/xxx.com\/API\/v3\/responseimports'"

Where am i going wrong?


Accepted Solutions
Six Stars

Re: Powershell command using tSystem

hi,

 Change the slashes from \\ to //


All Replies
Six Stars

Re: Powershell command using tSystem

hi,

 Change the slashes from \\ to //

Six Stars

Re: Powershell command using tSystem

oh God!! This was the culprit ..Thanks a lot

Six Stars

Re: Powershell command using tSystem

Hi, this command works fine when I run it through talend:

"cmd /c start powershell -noninteractive C://Curl_windows//src//curl.exe -H 'X-API-TOKEN:qEa9E1nqZWY5zekZd' -F 'surveyId=SV_8dpqGnJ3' -F 'file=@C://VocalCom//surveyresponseimport.csv;type=text/csv' 'https://qualtrics.com//API//v3//responseimports'"

 

But when I deploy the job and run through karaf, the command is unable to upload the file. 

 

Could you please suggest any alternative?

 

 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.