CSV as dataset doesn't work

[Riccardo]

Hello,

I'm tring to use a csv as a dataset for intersect operation in geo operations SaaS.

Here is the code:

TABLE:
Load * Extension GeoOperations.ScriptEval('
  SELECT * FROM Intersects()
  DATASOURCE testpoints CSV 
  	  	url="https://www.dropbox.com/s/pt2j6nl0gz73h4o/testpoints.csv?dl=0",
    keyField="C_SEZ",
    geometryField="G_SEZ_CEN",
    fieldSeparator="COMMA",
    recordSeparator="NEWLINE",
    stringQuotes="DOUBLEQUOTE",
    encoding="UTF-8",
    geometryType="POINT",
    crs="Auto"
', TABLE_WITH_POLIGON_FROM_PRECEDING_TRAVELAREA);

but Qlik returns this error:

Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'Failed to create dataset testpoints: Unknown geometry field in CSV, G_SEZ_CEN'

How can I resolve this issue?

Thanks

Riccardo

[Patric_Nordstrom · Accepted solution]

Must be direct access, change to dl=1

https://www.dropbox.com/s/pt2j6nl0gz73h4o/testpoints.csv?dl=1 or

https://dl.dropbox.com/s/pt2j6nl0gz73h4o/testpoints.csv?dl=0