Query Issue - Generic JDBC - Execute
Using a Generic JDBC - Execute snap at the beginning of my pipeline with a hard-coded SQL query that has no issues running from any other place (workbench, phpstorm, etc) returns 800 results and an e...
Forum Discussion
Okay so we’re getting there.
I’ve re-configured the Mapper and applied a few other changes but now the pipeline is returning an error:
Stacktrace: Metadata failed to load for ‘insert file location here’
Resolution: Check for URL syntax and file access permission
I read another article on here and wonder if it has something to do with setting up an Account in the File Reader Snap using Basic Auth?
The file is situated in a folder in SnapLogic under my username.
The first two characters are likely the byte order mark, this is automatically handled by the CSV Parser Snap. I'd suggest you use the HTTP Client snap and set the output view type to binary, then forward the contents to a CSV Parser Snap directly. Alternatively, you can use a Mapper or Document to Binary to convert the output of REST Get to a binary and then send it to a CSV Parser Snap. Below are screenshots of the HTTP Client snap views tab (with the output set to Binary), a pipeline to compare doing this with REST Get vs. HTTP Client, and a screenshot of the Mapper converting the entity from the REST Get to the content of binary output data.
