Convert a Connected Table to Normal Table

Question

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.&nbsp; &nbsp;It is on replace mode.This means that records are only added/removed once a day - and not on a steady state.&nbsp; 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 tableb) disconnect the google drive integration, and turn this into a regular tableI 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------------------------------

geoffbarrenger · Accepted Answer

ben_simonsuccess!! thank you - had to post a blank discussion first and then edited it - but it worked!&nbsp;&nbsp;

markshnier__you · Answer

There is no way to add records to a Connected Sync Table.&nbsp;
but super easy to disconnect.Table SettingsGoogle Drive Connection and click to disconnect.but once disconnected you cannot revert to connected.so for sure fully test you alternate method on another normal table first.&nbsp;
You can probably Copy the table to test and get all your fields set up. &nbsp;Go to the Table Home page in old view and use the More... button.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

ben_simon · Answer

Glad to hear it! First ones through the wall always get bloody. Thanks for helping us break in the new system, we'll iron out all the issues and get us back to having the experience people in The Qrew deserve. Thanks Geoff.

geoffbarrenger · Answer

Hi MarkShnier__You - I'm responding on an old message because I can't create new posts!! I sent an email to community@quickbase.com&nbsp; but am hoping you might be able to help out - any ideas??&nbsp; haven't had a question I couldn't have answered without searching the forums until now - so I guess when the replatform of the message boards happened I lost the ability to create posts!&nbsp; thank you! geoff.barrenger@ralphlauren.com

ben_simon · Answer

Hey Geoff, I can help here. Calendly - Ben Simon Let's set up a time for us to troubleshoot this together. You should be able to create new posts without issue. So let's just review together on a quick call.

ben_simon · Answer

Hey Geoff, I made an adjustment on your setup. Can you see if you can start a new post now?&nbsp;

Forum Discussion

Convert a Connected Table to Normal Table

8 Replies