Missing values for parameters in: bulkUpdateRows

💬 App Building
1 
{{ 
  [{"id": formatDataAsArray(skusNotInPO.data).find(sku => sku.unique_sku_id === recentSkuAdded.value)?.unique_sku_firestore_id || null,
"sku":  formatDataAsArray(skusNotInPO.data).find(sku => sku.unique_sku_id === recentSkuAdded.value)?.unique_sku_english_description || null,
"qty": 0,
"payable": 0,
"cp": poTable.data.invoice_consumer_price_pkr[poTable.data.sku_firestore_id.length -1 ],
"comment": null,
"vendor_invoice_code": null,
"vendor_sku_tax_type": poTable.data.vendor_sku_tax_type[poTable.data.sku_firestore_id.length -1 ],
"tierage": poTable.data.invoice_selling_units_per_procurement_unit[poTable.data.sku_firestore_id.length],
"advance_tax": advanceTaxPct.data.advance_tax_pct[0] / 100.0,
"per_unit_pp_with_tax": `=D${poTable.data.sku_firestore_id.length}/(C${poTable.data.sku_firestore_id.length} + 2*I${poTable.data.sku_firestore_id.length + 2})`,
"advance_tax_ratio": `=1+J${poTable.data.sku_firestore_id.length}`,
"advance_tax_rs": `=(K${  poTable.data.sku_firestore_id.length}/L${ poTable.data.sku_firestore_id.length})*(L${  poTable.data.sku_firestore_id.length}-1)`,
"pp_pre_advance_tax": `=K${  poTable.data.sku_firestore_id.length}/L${  poTable.data.sku_firestore_id.length}`,
"sales_tax_ratio": `=IFS(H${  poTable.data.sku_firestore_id.length}="VAT", 1.18, H${  poTable.data.sku_firestore_id.length}="VAT (imported)", 1.25, H${poTable.data.sku_firestore_id.length}="3rd Schedule", 1.18, H${poTable.data.sku_firestore_id.length}="3rd Schedule (imported)", 1.25, H${  poTable.data.sku_firestore_id.length}="8th Schedule", 1.1, H${poTable.data.sku_firestore_id.length}="No Tax", 1)`,
"sales_tax_rs": `=IF(AND(H${poTable.data.sku_firestore_id.length}<>"3rd Schedule",H${poTable.data.sku_firestore_id.length}<>"3rd Schedule (imported)"),(N${poTable.data.sku_firestore_id.length}/O${  poTable.data.sku_firestore_id.length})*(O${  poTable.data.sku_firestore_id.length}-1),(E${  poTable.data.sku_firestore_id.length}/O${  poTable.data.sku_firestore_id.length})*(O${  poTable.data.sku_firestore_id.length}-1))`,
"total_sales_tax_rs": `=P${poTable.data.sku_firestore_id.length}*C${poTable.data.sku_firestore_id.length}*I${  poTable.data.sku_firestore_id.length}`,
"vendor_price_rs_pre_taxes": `=N${poTable.data.sku_firestore_id.length}/O${poTable.data.sku_firestore_id.length}`,
"total_tax_rs": `=P${poTable.data.sku_firestore_id.length}+M${  poTable.data.sku_firestore_id.length}`}]
}}

image
image1006×342 22.1 KB

The row is appended to the sheet, but still getting this error.

2

Hello @engineering-tajir ,

The error message "Missing values for parameters in: bulkUpdateRows" indicates that some required fields in your bulkUpdateRows request are either missing or null.

  1. Check for null values in required fields

  2. Ensure correct object structure

  • Your JSON array needs to follow the exact structure expected by bulkUpdateRows. Validate the schema of the expected data.
3 Likes
3

Hi @engineering-tajir,

Thanks for reaching out! It's a little tricky to tell why the error is coming up without seeing how the dynamic values are being evaluated, and I haven't be able to reproduce this error. :thinking: I'm wondering if one of the values is malformed.

Do you get any errors if you copy and paste the values to append into a transformer and return the values? Do they all evaluate as expected? Do you get this error every time the append query runs?