Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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