Zoho Creator - Getting started in Peliqan

# Required Inputs
report_link_name = "All_Orders"
form_link_name = "Customer_Order_Form"

# Required Connection
dbconn = pq.dbconnect(pq.DW_NAME)
zoho_creator_api = pq.connect('Zoho Creator')


# Fetching fields of the form
form_fields = {
    'form_link_name': form_link_name
}
result = zoho_creator_api.get('form_fields', form_fields)
# st.json(result)

# analyze the fiel available in form and type of fields.

# Creating Record through form
records = {
  'payload': {
      'Customer_ID_Admin_Only': '7634',
      'Email_Admin_Only': "test@example.com",
      'Support_Ticket_ID': "2930",
      'Product_Name': "RehaVib",
      'Purchase_Date': "10-Jan-2020", # date field
      'Ticket_Status': 'Open', # single choice field
      'Account_Status_Admin_Only': "Inactive",  # single choice field
  },
  'form_link_name': form_link_name,
}
result = zoho_creator_api.add('records', records)
st.json(result)

# Required Inputs
report_link_name = "All_Orders"
form_link_name = "Customer_Order_Form"
record_id = '258987000000009003'

# Required Connection
dbconn = pq.dbconnect(pq.DW_NAME)
zoho_creator_api = pq.connect('Zoho Creator')

# Fetching object by record_id
records = {
    'record_id': record_id,
    'report_link_name': report_link_name
}
result = zoho_creator_api.get('records', records)
st.json(result)

# updating values and updating record in Zoho creator
records = {
    'payload': {
        "Account_Status_Admin_Only":"Inactive",
        "Email_Admin_Only":"test@example.com",
        "Delivery_Status":"In Transit",
        "Support_Ticket_ID":"2930",
        "Product_Name":"RehaVib",
        "ID":"258987000000009003",
        "Customer_ID_Admin_Only":"7634",
        "Ticket_Status":"Open",
        "Purchase_Date":"11-Jan-2020"
    },
    'record_id': record_id,
    'report_link_name': report_link_name
}
result = zoho_creator_api.update('records', records)
st.json(result)