Forum Discussion

SyedSalik's avatar
SyedSalik
Qrew Member
11 years ago

Integrating Data from XML file into Tables - Records-Fields of Quickbase App

Hello everyone,

So I did went through a lot of videos, and question/answers but was not able to figure out in a clear and concise manner on how to achieve the following:

I want to start very very simple ...

Here is the scenario

- I have an App that has a table and in that table there are records as shown in the attached image.

- There is a field of Serial number and Device Model which I DO NOT want to fill in manually, I want to Integrate data to it from an external xml file which contains this data

- How do I make this happen ? Where to write the code ? How to pull the data ? how to authenticate quickbase ? e.t.c

- Attached is the XML file picture also which I want to use to feed data into Quickbase.

Appreciate your help.

APIs and custom code
roles and permissions
Tables and fields
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    11 years ago
    The screenshot of your XML file is a xsd schema file so it only describes the structure of the XML file that will contain the actual data. What you will need to do is use the image onload technique to insert a <input type=file accept=xml> into your form so you can select the xml data file that contains serial number and device model. When the XML file is selected you use jQuery to parse out the serial number and device model information and feed it into the two fields in your table.

    There was a similar question recently asked and answered which you might be able to use as a starter:


    https://quickbase-community.intuit.com/questions/1013515

    If you need help feel free to contact me off-world using the contact information in my profile.
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    7 years ago
    Hey Dan, the link to the other question doesn't work anymore. My company is trying similar to this, and attempting to automate this process... I've been researching the IOL technique. The hurdle we've had is sending the XML to QB itself so far.