Zoho creator to Quickbooks customer mapping
So I wanted to be able to create a customer and add info from a created sheet when it is submitted. I am able to create the customer and add Family name, display name, and billing and shipping address info with the following code:
//Declare Map Variable to hold the customer details
Customer_Details = map();
temp = Quote_Sheet [ID == input.Customer_Name];
//Add the customer details to the map variable
Customer_Details.put("FullyQualifiedName", temp.Customer_Name);
Customer_Details.put("DisplayName", temp.Customer_Name);
//declare map variable to hold the shipping address
Shipping_Address = map();
//add shipping address to the map variable
Shipping_Address.put("Line1", input.Delivery_Address);
Shipping_Address.put("Country", "USA");
//declare map variable to hold the billing address
Bill_Address = map();
//add billing address to the map variable
Bill_Address.put("Line1", input.Billing_Address);
Bill_Address.put("Country", "USA");
//adding the shipping address to customer details
Customer_Details.put("ShipAddr", Shipping_Address);
//adding the billing address to customer details
Customer_Details.put("BillAddr", Bill_Address);
//creating the customer in the Quickbooks Customer module with connecton name "NameofConnection" and account id "1XXXXXXXXX"
createResponse = intuit.quickbooks.create("NameofConnection", "Customer", "1XXXXXXXXX", Customer_Details);
What I'm having a hard time with though, is adding email, phone number, first name, middle name, and last name. Does anyone know the map variable names for those values? I've tries :
Customer_Details.put("Email", temp.Customer_Email);
Customer_Details.put("Phone", temp.Customer_Phone);
but these variable names ("Email" and "Phone") don't seem to get them to map and cause an error.