How to pass parameters as arrays?

[ericemc3]

I am trying to geocode a csv file. http_post_multipart() is a wonderful function for that, thanks a lot!

But i have trouble passing a "columns" parameter as an array.

SET VARIABLE CSV_BLOB = ( 
	FROM read_blob('sage-femmes31.csv')
	SELECT CONTENT 
);

LOAD http_request ;

SELECT (http_post_multipart(
  'https://data.geopf.fr/geocodage/search/csv/',
  files := [{ name: 'data',
		      content: getvariable('CSV_BLOB'), 
		      filename: 'input_geocodage.csv' 
		   }],
  fields := {columns: 'adresse'}
).body)
.decode() 
;

This works if columns is a string.

But this does not:

SELECT (http_post_multipart(
  'https://data.geopf.fr/geocodage/search/csv/',
  files := [{ name: 'data',
		      content: getvariable('CSV_BLOB'), 
		      filename: 'input_geocodage.csv' 
		   }],
  fields := {columns: ['adresse', 'dept']}
).body)
.decode() 
;

{"code":400,"message":"At least one given column name is unknown"}

It looks like columns is received as a string: "[adresse,dept]" instead of an array

From the API swagger:

sage-femmes31.csv

[ericemc3]

Hello, would you expect more elaboration from me on that point?