Hello,I have an array of objects that i need to simply add a key to. However, im not a able to find a way of doing this. attached are screen shots of the input and desired output. Any advise is much appreciated.Input:[{fromCurrency:{code: "CUC",name:...
I would like to create a pipeline which downloads excel file from this webpage https://www.eia.gov/electricity/data/eia861m/#salesrevenue every month. I am currently using web scraping and python to download the excel file. Can we do webscraping or i...
I am using SOAP execute snap using basic authorization , but getting below error ."error":"Authorization loop detected on ConduitCould you help me the reason for this? I tried to logon SAP with user and it works fine.logsReason:Authorization loop de...
Hello all,I have created a triggered task to receive the webhooks generated from another web application when changes are detected. This works well with Postman, I can use the task URL and the authentication token in the Authorization header, and SL ...
Anyone aware on how to insert the data into excel file from a specific line number? My requirement is to insert/create the data in excel file from line number 6. From lines 1-5 I will have the header information. We designed all pipelines to read the...
Hi there,I have one input json like as follows:{ "isValid": true, "logId": "9IE9BkOwxvrCwn_Ot7p4o-1699858392", "contractId": 1, "erpVendorId": "VID123", "erpVendorName": null, "erpVendorLocationId": "VSID789", "vendor": [ ...
I have a input json file like below please see the dummy example below{ "totalCount": 2, "dataList": [ { "IFA": "IFA1", "voltage": "200", "power": "100", "equipid": "1234ABC", "SN": "SalesForce-1" }, { "IFA": "IFA2", "voltage": "200", "power": "100",...
Running into an issue I can't solve.I'm unable to have Snap create a table (if not present) with a DATE datatype field (instead of a string datatype) if the first import row encountered is a null or empty date string. That is, I want the newly creat...
