i tried to pull the report from QuickBase but it is giving error report too large
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2022 11:50 PM
hi
i tried to pull the report from below query
%python
df = quickbasePull('b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u','bqmnP8jm7',24)
but it is giving me error report too large
then i tried below
%python
import pyqb
from pyspark.sql import *
import pandas as pd
qbc = pyqb.Client(url='https://tvcm.quickbase.com/',user_token='b5zj8k_pbz5_0_cd5h4wbbp77n4nvp56b4u',database='bq2ma8jm7')
result = qbc.doquery(qid=24,database='bqmnP8jm7',fields=["5","6","7","8"])
samp = result['record']
df = pd.DataFrame(samp)
df = spark.createDataFrame(df)
df.createOrReplaceTempView('otl')
iam getting below result instead of no of column
plz help to pull the large amount of data from quickbase
Labels:
- Labels:
-
Hi
-
Import Pandas