Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
DarthMaul
Contributor
Contributor

REST Connector Script : pass Format Specs with LOAD and SELECT syntax

Hey,

i have a set up a REST Connection and want to load data using a script in the data load editor:

The script looks like this:

LIB CONNECT TO 'RESTConnectionName';

LOAD

[Field1],

[Field2];

SQL SELECT

"Field1",

"Field2"

FROM CSV (header on, delimiter ",", quote """") "CSV_Source"

WITH CONNECTION (QUERY "name" "extraction_Name");

 

I´m looking for a way to give format specs, but i can´t see where this would fit using this syntax.

I want to tell it the encoding of the data for example using codepage is 65001, etc...

(I want to avoid using ApplyCodepage() on every field).

However it won´t let me put it in the options section right after "FROM CSV".

 

Does anyone know where i can specify this in the given syntax?

Greets

Labels (2)
0 Replies