GeoffBarrenger
2 years agoQrew Captain
Convert a Connected Table to Normal Table
Greetings,
In order to populate one of the tables in an application, a user is downloading a large CSV (over a million rows) from a database, and loading that CSV into google drive, so that it can be imported into QuickBase daily. It is on replace mode.
This means that records are only added/removed once a day - and not on a steady state. Because of that, there is a delay throughout the day.
We have an opportunity to have the records updated from this service in the json format - which would reduce manual effort, and give us a near real time view.
We attempted a test, but the response was:
------------------------------
Geoff Barrenger
------------------------------
In order to populate one of the tables in an application, a user is downloading a large CSV (over a million rows) from a database, and loading that CSV into google drive, so that it can be imported into QuickBase daily. It is on replace mode.
This means that records are only added/removed once a day - and not on a steady state. Because of that, there is a delay throughout the day.
We have an opportunity to have the records updated from this service in the json format - which would reduce manual effort, and give us a near real time view.
We attempted a test, but the response was:
{
"data": [],
"metadata": {
"createdRecordIds": [],
"lineErrors": {
"1": [
"You don't have permission to add records to this table."
]
},
"totalNumberOfRecordsProcessed": 1,
"unchangedRecordIds": [],
"updatedRecordIds": []
}
}
Authentication was checked out, and service was able to add records to a non-connected table with the same authentication:
{
"data": [],
"metadata": {
"createdRecordIds": [
1558344
],
"totalNumberOfRecordsProcessed": 1,
"unchangedRecordIds": [],
"updatedRecordIds": []
}
}
Is it possible to either:
a) allow for a service to create/remove records into a connected table
b) disconnect the google drive integration, and turn this into a regular table
I would like to keep the existing table rather than create another, because there are many formulas, and relations to other tables.
Hoping someone might be an expert in connected tables!
------------------------------
Geoff Barrenger
------------------------------
ben_simonsuccess!! thank you - had to post a blank discussion first and then edited it - but it worked!