AndrewS
3 years agoQrew Trainee
Parse data
Hi,
Does any body have experience with connecting the Quick Books Online?
Quick Books Online has "EstimateLine" table, which connected to "Estimates", but "EstimateLine" does not available for the import in the QuckBase, instead "EstimateLine" table has "Line" field and combine all item's data:
Below an example of "Line" field from "Estimates" table:
[('1',1,'3/8" Clear Tempered','193.20',null,'SalesItemLineDetail',('Glass:Clear Temper.37500','4126','2 - Residential','7200000000001039693','193.2',null,null,null,null,'1',null,'NON','2021-06-01'),null), ('2',2,'CRL:SCU4CH - Polished Chrome Square Style Hole-In-Glass Fixed Panel U-Clamp','6.56',null,'SalesItemLineDetail',('CRL:SCU4CH/PolishedChromeU-Clamp','5297','2 - Residential','7200000000001039693','3.28',null,null,null,null,'2',null,'NON','2021-06-01'),null), ('3',3,'SDCD38BA - Brite Anodized 3/8" Fixed Panel Shower Door Deep U-Channel 95"','4.02',null,'SalesItemLineDetail',('C.R.Laurence:SDCD38BA','3013','2 - Residential','7200000000001039693','13.02',null,null,null,null,'0.309',null,'NON','2021-06-01'),null), ('4',4,'BM6X6CH - Polished Chrome 6" BM Series Tubular Back-to-Back Pull Handle','19.46',null,'SalesItemLineDetail',('C.R.Laurence:BM6X6CH','1123','2 - Residential','7200000000001039693','19.46',null,null,null,null,'1',null,'NON','2021-06-01'),null), ('5',5,'GEN037CH - Polished Chrome Geneva 037 Series Wall Mount Full Back Plate Standard Hinge','46.98',null,'SalesItemLineDetail',('C.R.Laurence:GEN037CH','2297','2 - Residential','7200000000001039693','23.49',null,null,null,null,'2',null,'NON','2021-06-01'),null), ('6',6,'P990WS - Clear Co-Extruded Bottom Wide w/Drip Rail for 3/8" Glass','2.12',null,'SalesItemLineDetail',('C.R.Laurence:P990WS','2726','2 - Residential','7200000000001039693','7.19',null,null,null,null,'0.2947',null,'NON','2021-06-01'),null), ('7',7,'PCC10 - ''Y'' Jamb Seal with Soft Leg for 3/8" Glass','6.11',null,'SalesItemLineDetail',('C.R.Laurence:PCC10','2732','2 - Residential','7200000000001039693','6.11',null,null,null,null,'1',null,'NON','2021-06-01'),null), ('8',8,'33SC - Clear 33S Silicone Sealant','2.07',null,'SalesItemLineDetail',('C.R.Laurence:33SC','820','2 - Residential','7200000000001039693','4.14',null,null,null,null,'0.5',null,'NON','2021-06-01'),null), (null,null,null,'280.52',null,'SubTotalLineDetail',null,null)]
how we can parse data from the "Line" field "Estimates" table, and create another "EstimateLine" table in the QuickBase?
------------------------------
Andrew S
------------------------------
Does any body have experience with connecting the Quick Books Online?
Quick Books Online has "EstimateLine" table, which connected to "Estimates", but "EstimateLine" does not available for the import in the QuckBase, instead "EstimateLine" table has "Line" field and combine all item's data:
Below an example of "Line" field from "Estimates" table:
[('1',1,'3/8" Clear Tempered','193.20',null,'SalesItemLineDetail',('Glass:Clear Temper.37500','4126','2 - Residential','7200000000001039693','193.2',null,null,null,null,'1',null,'NON','2021-06-01'),null), ('2',2,'CRL:SCU4CH - Polished Chrome Square Style Hole-In-Glass Fixed Panel U-Clamp','6.56',null,'SalesItemLineDetail',('CRL:SCU4CH/PolishedChromeU-Clamp','5297','2 - Residential','7200000000001039693','3.28',null,null,null,null,'2',null,'NON','2021-06-01'),null), ('3',3,'SDCD38BA - Brite Anodized 3/8" Fixed Panel Shower Door Deep U-Channel 95"','4.02',null,'SalesItemLineDetail',('C.R.Laurence:SDCD38BA','3013','2 - Residential','7200000000001039693','13.02',null,null,null,null,'0.309',null,'NON','2021-06-01'),null), ('4',4,'BM6X6CH - Polished Chrome 6" BM Series Tubular Back-to-Back Pull Handle','19.46',null,'SalesItemLineDetail',('C.R.Laurence:BM6X6CH','1123','2 - Residential','7200000000001039693','19.46',null,null,null,null,'1',null,'NON','2021-06-01'),null), ('5',5,'GEN037CH - Polished Chrome Geneva 037 Series Wall Mount Full Back Plate Standard Hinge','46.98',null,'SalesItemLineDetail',('C.R.Laurence:GEN037CH','2297','2 - Residential','7200000000001039693','23.49',null,null,null,null,'2',null,'NON','2021-06-01'),null), ('6',6,'P990WS - Clear Co-Extruded Bottom Wide w/Drip Rail for 3/8" Glass','2.12',null,'SalesItemLineDetail',('C.R.Laurence:P990WS','2726','2 - Residential','7200000000001039693','7.19',null,null,null,null,'0.2947',null,'NON','2021-06-01'),null), ('7',7,'PCC10 - ''Y'' Jamb Seal with Soft Leg for 3/8" Glass','6.11',null,'SalesItemLineDetail',('C.R.Laurence:PCC10','2732','2 - Residential','7200000000001039693','6.11',null,null,null,null,'1',null,'NON','2021-06-01'),null), ('8',8,'33SC - Clear 33S Silicone Sealant','2.07',null,'SalesItemLineDetail',('C.R.Laurence:33SC','820','2 - Residential','7200000000001039693','4.14',null,null,null,null,'0.5',null,'NON','2021-06-01'),null), (null,null,null,'280.52',null,'SubTotalLineDetail',null,null)]
how we can parse data from the "Line" field "Estimates" table, and create another "EstimateLine" table in the QuickBase?
------------------------------
Andrew S
------------------------------