Snaps

Reading data from HTML Table

Hi Guys , I am trying to read a data from an HTML table. Used REST API to connect to the webpage and able to get the response. However parsing the table is really challenging. I tried the XML parser , mapper( html.decode ) , java script , JSON parser...

Convert string to Timestamp

Hello everyone, can someone please help convert string “20240311113047” into TIMESTAMP format? Thank you!

Resolved! SOAP Customize Envelope

Do you have a sample for soap execute>customized envelope> foreach Function? What’s the language we should use in customized envelope?

Resolved! How to check if the file not found but the Directory Browser returns nothing

The Directory Browser returns nothing when the specific file name cannot be found. So, how can I check if the file is found in the next snap like Router. I tried some ways like: $ == null or .get but it doesn't work. Please help me overcome this. Ma...

Issue with "not exists" clause in Oracle Execute Snap

Hello Community,I'm currently encountering an issue with the usage of the "not exists" clause within an Oracle Execute Snap. It appears that the Execute Snap is not properly excluding results under the "not exists" subquery. Has anyone else encounter...

How to know the all column names(input columns) using expression in mapper

I want to know list of all input columns in the pipeline using expression in mapper. Please help

Mapper Snap - Preparing fixed width text datafile

I use a Generic JDBC Execute Snap to run a SQL query which fetches multiple column data and few of them are NUMERIC. The output from this SQL query is an input to the mapper and the mapper is being used to create fixed width text datafile. When I try...