CMD to create table bulk import [Apr 15]

Discord-Discussions
1

:raising_hand_man: vishal.gandhi asked

Hello

Is there a command line available to create the table or bulk import CSV to a table ; for tables with high number of columns it will be helpful

2

:raising_hand_man: vishal.gandhi replied

hello wingkwong

3

:raising_hand_man: wkw replied

if u go to swagger ui, then execute a api call, you will see the curl command

4

:raising_hand_man: vishal.gandhi replied

trying

5

:raising_hand_man: vishal.gandhi replied

how do i go to swagger UI

6

:raising_hand_man: wkw replied

assuming you r using rest api project, check this out

7

:raising_hand_man: wkw replied

https://docs.nocodb.com/developer-resources/accessing-apis#rest-apis

8

:raising_hand_man: wkw replied

after executing an api call, u should see sth like

image0

9

:raising_hand_man: wkw replied

with similar idea, you may check out https://docs.nocodb.com/developer-resources/rest-apis#examples

10

:raising_hand_man: vishal.gandhi replied

Able to access APIs now. I will try this out. Thank you.

11

:raising_hand_man: vishal.gandhi replied

however is there API for create table

12

:raising_hand_man: wkw replied

api for create table will be avilable in the next release

13

:raising_hand_man: vishal.gandhi replied

awesome thank you so much

14

:raising_hand_man: vishal.gandhi replied

i am trying to import CSV and its failing with 400

15

:raising_hand_man: vishal.gandhi replied

.returning() is not supported by mysql and will not have any effect.

POST /nc/work_gkos/api/v1/planview/bulk 400 17168 - 22.880 ms

.returning() is not supported by mysql and will not have any effect.

POST /nc/work_gkos/api/v1/planview/bulk 400 17168 - 28.775 ms

.returning() is not supported by mysql and will not have any effect.

POST /nc/work_gkos/api/v1/planview/bulk 400 17168 - 13.598 ms

16

:raising_hand_man: vishal.gandhi replied

this is as per docker container logs

17

:raising_hand_man: wkw replied

pls create an issue on github with some details (project info, steps to reproduce etc)

18

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs