Forum Discussion

RameshSingh's avatar
RameshSingh
Qrew Member
2 years ago

Json code not mapping

I have a quickbase pipeline which starts fetch json, prepare bulk upsert,iterate over json records, for each it needs to add a bulk upsert row and last step E is commit upsert. But seems like it doesn't add a bulk upsert output.

My json schema is {
  "type": "object",
  "properties": {
    "Company Name": {
      "type": "string"
    },
    "Company Id - Collection Status": {
      "type": "string"
    },
    "Days Past Due": {
      "type": "integer"
    },
    "BANK_ID": {
      "type": "string"
    },
    "Company Id (ref)": {
      "type": "string"
    },
    "Balance Past Due": {
      "type": "number"
    },
    "Credit Line Amount": {
      "type": "number"
    },
    "Last payment date": {
      "type": "string"
    },
    "Last payment amt": {
      "type": "number"
    },
    "LAST_PAYMENT_STATUS": {
      "type": "string"
    },
    "Company Level - Notes": {
      "type": "string"
    },
    "Notes": {
      "type": "string"
    },
    "Admin name": {
      "type": "string"
    },
    "Admin Phone Number": {
      "type": "string"
    },
    "Admin email": {
      "type": "string"
    },
    "DIVVY_GROWTH_EXECUTIVE_NAME": {
      "type": "string"
    },
    "COMPANY_BILLING_CYCLE": {
      "type": "string"
    },
    "COMPANY_PAYMENT_TERMS": {
      "type": "string"
    },
    "ADDRESS_LINE_1": {
      "type": "string"
    },
    "CITY": {
      "type": "string"
    },
    "STATE": {
      "type": "string"
    },
    "POSTAL_CODE": {
      "type": "string"
    }
  }
}

Let me know if you could help



------------------------------
XYZ
XYZ
------------------------------
No RepliesBe the first to reply