Thank you, @marioghersi!

By the way, it is also possible to specify a file name in the filePath option, like "filePath": "export/my-data.csv".

Hi @Mohid Khurram,

happy to announce that we have made documentation for this plugin.

Here is the link: https://backendless.com/feature/csv-to-from-database.

If you have any questions, we will be happy to help and answer them on our support forum.

Regards,

Stan

Hey @stanislaw_grin , I am new to backendless. Can you please tell me how to use this plugin? I wish to upload a csv which will populate a table in my database. I was unable to find any documentation. Does this plugin give us some API calls that we can use?

Try to use full csv url

@v_excelsior

with full csv url it works :)

thank you.

Can I use this api in the same way of backendless api?

I'm writing an api services coding in JS.

Thank you,

Elena.

Good job, my solution was a python code outside Backendless this is much better.

You can find the API at Cloud Code and this was my sample without all the options you provide.

{

"filePath": "export",

"tableName": "AutoLogin",

"tableOptions": {

"where": "",

"relations": [

"controles",

"cliente"

],

"relationsDepth": 1

}

}

Thanks you Mr. Stanislaw Grin for share your work.

@stanislaw_grin

yes, thank you!

Good to know because I was looking for filename option but was not there.

Thanks, Mario

Hello @elenaaralla,

so is everything works fine for you now?

@v_excelsior

Ignore the latest request for help;

I have to use backendless https calls :)

Could you tell me in more detail which problem you faced?

Regards, Dima

Hello,

I’m trying to use your service api and I was wondering if to import data from csv to table it is possible to specify only the path of the csv and the name of the table.

Thank you

Hi @Mohid Khurram, glad to see you here!

The documentation is unfortunately not ready yet, we will inform you as soon as we publish it.

For now, you can play with it without docs, you will need to invoke csv2table method.

Here is a description of this method:

Params:

• csvURL {string} - The URL of a csv to be parsed, required

• tableName {object} - The name of the table to write into, required

• options {object} - Optional

options params:

• columns {Array|Array|boolean} - Generate records as object literals instead of arrays. List of fields as an array, or true if auto-discovered in the first CSV line. Defaults to null. Affects the result data set in the sense that records will be objects instead of arrays. A value false, null, or undefined inside the column array skips the column from the output

• group_columns_by_name {boolean} - Convert values into an array of values when columns are activated and when multiple columns of the same name are found

• delimiter {string} - Set one or several field delimiters containing one or several characters. It defaults to , (comma)

• encoding {string} - Set the input and output encodings. Using null or false output the raw buffer instead of a string and it defaults to utf8

• escape {string} - Set the escape character as one character/byte only. It only applies to quote and escape characters inside quoted fields and it defaults to " (double quote)

• from {number} - Start handling records from a requested number of records. Count is 1-based, for example, provides 1 (and not 0) to emit first record

• from_line {number} - Start handling records from a requested line number

• ignore_last_delimiters {boolean} - Disregard any delimiters present in the last field of the record, require the column option when true

• ltrim {boolean} - If true, ignore whitespace immediately following the delimiter (i.e. left-trim all fields). Defaults to false. Does not remove whitespace in a quoted field

• rtrim {boolean} - If true, ignore whitespace immediately preceding the delimiter (i.e. right-trim all fields). Defaults to false. Does not remove whitespace in a quoted field

• ltrim {string} - Name of header-record title to name objects by; the string value must not be empty and it must match a header value

• quote {string} - Optional character surrounding a field as one character only; disabled if null, false or empty; defaults to double quote

• record_delimiter {string|string[]>} - One or multiple characters used to delimit records; defaults to auto discovery if not provided. Supported auto discovery methods are Linux ("\n"), Apple ("\r") and Windows ("\r\n") row delimiters

• to {number} - Stop handling records after the requested number of records.

• to_line {number} - Stop handling records after the requested line number.

• trim {boolean} - If true, ignore whitespaces immediately around the delimiter. Defaults to false. Does not remove whitespace in a quoted field.

Hope this helps.