https://questdb.io logo
Title
a

alex.b

02/27/2023, 10:24 AM
Hi, I have a problem with the import data through the rest api. I get the error
not enough lines [table=price_tickers]
when send one csv row only. So is there conf for set minimum lines count?
a

Andrey Pechkurov

02/27/2023, 10:27 AM
Hi Alex, Does your file include column headers? If not, did you try
forceHeader=false
?
a

alex.b

02/27/2023, 10:28 AM
No, will try. Thank you
Still get it
I send only data rows with GET-query parameters: forceHeader=false&name=<name>
Is the header row required when I have only one data row in my csv?
a

Andrey Pechkurov

02/27/2023, 10:40 AM
Forgot one more thing:
&forceHeader=false&delimiter=%2C
-
delimiter=%2C
here instructs the database to use comma as the value delimiter
Could you try that? I've just checked locally and the table seems to import fine
a

alex.b

02/27/2023, 10:41 AM
Yeah! It works! Thank you
n

Nicolas Hourcard

02/27/2023, 10:44 AM
hey alex, welcome to our community. Is this use case market data related?
a

alex.b

02/27/2023, 10:46 AM
partially yes, but I am on the stage of the testing qdb for my system now
n

Nicolas Hourcard

02/27/2023, 10:49 AM
thanks for letting me know, we’re here to help as you make progress. Is this a personal project of company wide ?