I have a python script which creates an API Request Body to build a Quickbooks Invoice based on Salesforce Products.
First I get the products from Salesforce, which come as Line Items.
Then I take the comma separated inputs of the Product, Cost, and Description from Salesforce, and match them to products in Quickbooks to build the API Body.
The issue is if the description is blank, the line item is not included in the input, which leads to a mismatch in the number of descriptions, and products.
Is there any way to not have these blank line items not ignored, so the script can know that the description was blank?
The preview when selected data shows the empty value (see yellow)
But the blank field is skipped on the input so theres no way to handle it in any task.
Any help greatly appreciated.
Really appreciate you popping back in to share both the formula you used, and the community thread where you found it - I’ll get your reply marked as the best answer to help surface this info to others in the Community.