topic Re: Powershell command using tSystem in Talend Studio

Powershell command using tSystem

Anonymous — Sat, 16 Nov 2024 08:37:33 GMT

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?

Re: Powershell command using tSystem

Anonymous — Thu, 01 Mar 2018 10:54:21 GMT

hi,

Change the slashes from \\ to //

Re: Powershell command using tSystem

Anonymous — Thu, 01 Mar 2018 11:10:18 GMT

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

Re: Powershell command using tSystem

Anonymous — Mon, 05 Mar 2018 04:52:22 GMT

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?