FSM work order creation on books quote approval
in order to create a work order in FSM based on a books quote being approved.
I have changed the connection name to the one that connects my FSM and books but get the following error:
Check and update the code in line 27 as there is a Exception : Invalid JSON Format String
estimateID = estimate.get("estimate_id");
estimatedate = estimate.get("date").toDate();
organizationID = organization.get("organization_id");
resp = zoho.books.getRecordsByID("Estimates",organizationID,estimateID);
estimateResp = resp.get("estimate").toMap();
bl_address = estimateResp.get("billing_address").toMap().get("address");
bl_city = estimateResp.get("billing_address").toMap().get("city");
bl_country = estimateResp.get("billing_address").toMap().get("country");
bl_state = estimateResp.get("billing_address").toMap().get("state");
bl_zip = estimateResp.get("billing_address").toMap().get("zip");
sh_address = estimateResp.get("shipping_address").toMap().get("address");
sh_city = estimateResp.get("shipping_address").toMap().get("city");
sh_country = estimateResp.get("shipping_address").toMap().get("country");
sh_state = estimateResp.get("shipping_address").toMap().get("state");
sh_zip = estimateResp.get("shipping_address").toMap().get("zip");
summary = estimateResp.get("estimate_number");
due_date = estimateResp.get("date");
books_customer_id = estimateResp.get("contact_persons_details").toMap().get("contact_person_id");
con_response = invokeurl
[
url :"https://fsm.zoho.com/fsm/v1/Contacts/search?api_name=ZBilling_Id&value=" + books_customer_id
type :GET
connection:"fsmconnection"
];
ContatsRespMap = con_response.get("data").toMap();
id = ContatsRespMap.get("id");
conDetails = zoho.fsm.getRecordById("Contacts",id);
data = conDetails.get("data");
Service_Address = data.toMap().get("Service_Address");
Billing_Address = data.toMap().get("Billing_Address");
Billing_Address_Id = Billing_Address.toMap().get("id");
Service_Address_Id = Service_Address.toMap().get("id");
service_Address_map = {"id":Service_Address_Id,"Service_Street_1":sh_address,"Service_Street_2":null,"Service_City":sh_city,"Service_State":sh_state,"Service_Country":sh_country,"Service_Zip_Code":sh_zip};
Billing_Address_map = {"id":Billing_Address_Id,"Billing_Street_1":bl_address,"Billing_Street_2":null,"Billing_City":bl_city,"Billing_State":bl_state,"Billing_Country":bl_country,"Billing_Zip_Code":bl_zip};
line_items = estimateResp.get("line_items").toList();
i = 1;
j = 1;
Service_Line_Items_List = list();
Part_Line_Items_List = list();
Sub_total = 0;
Tax_Amount = 0;
Grand_Total = 0;
tax = Map();
for each line_item in line_items
{
item_id = line_item.toMap().get("item_id");
type = zoho.books.getRecordsByID("Items",organizationID,item_id).get("item").toMap().get("product_type");
if(type == "service")
{
Service_Line_Items_Map = Map();
line_item_name = line_item.toMap().get("name");
quantity = line_item.toMap().get("quantity");
tax_name = line_item.toMap().get("tax_name");
tax_id = line_item.toMap().get("tax_id");
tax_percentage = line_item.toMap().get("tax_percentage");
tax = {"Tax_Name":tax_name,"Tax_Exemption_Code":null,"Tax_Id":tax_id,"Tax_Percentage":tax_percentage,"Tax_Exemption_Id":null};
rate = line_item.toMap().get("rate");
ServiceResp = invokeurl
[
type :GET
connection:"fsmconnection"
];
ServiceRespMap = ServiceResp.toMap().get("data").toMap();
service_id = ServiceRespMap.get("id");
Service_Line_Items_Map.put("Service",service_id);
Service_Line_Items_Map.put("Quantity",quantity);
Service_Line_Items_Map.put("List_Price",rate);
Line_Item_Amount = quantity.toDecimal() * rate.toDecimal();
Sub_total = Sub_total + Line_Item_Amount;
Service_Line_Items_Map.put("Tax",tax);
Service_Line_Items_Map.put("Line_Item_Amount",Line_Item_Amount);
Service_Line_Items_Map.put("Sequence",i);
Service_Line_Items_Map.put("Contact",id);
i = i + 1;
Service_Line_Items_List.add(Service_Line_Items_Map);
}
else
{
Part_Line_Items_Map = Map();
line_item_name = line_item.toMap().get("name");
quantity = line_item.toMap().get("quantity");
tax_name = line_item.toMap().get("tax_name");
tax_id = line_item.toMap().get("tax_id");
tax_percentage = line_item.toMap().get("tax_percentage");
tax = {"Tax_Name":tax_name,"Tax_Exemption_Code":null,"Tax_Id":tax_id,"Tax_Percentage":tax_percentage,"Tax_Exemption_Id":null};
rate = line_item.toMap().get("rate");
ServiceResp = invokeurl
[
type :GET
connection:"fsmconnection"
];
ServiceRespMap = ServiceResp.toMap().get("data").toMap();
service_id = ServiceRespMap.get("id");
Part_Line_Items_Map.put("Part",service_id);
Part_Line_Items_Map.put("Quantity",quantity);
Part_Line_Items_Map.put("List_Price",rate);
Line_Item_Amount = quantity.toDecimal() * rate.toDecimal();
Sub_total = Sub_total + Line_Item_Amount;
Part_Line_Items_Map.put("Line_Item_Amount",Line_Item_Amount);
Part_Line_Items_Map.put("Tax",tax);
Part_Line_Items_Map.put("Sequence",j);
j = j + 1;
Part_Line_Items_List.add(Part_Line_Items_Map);
}
}
info Service_Line_Items_List;
temp_ser_line_item = Service_Line_Items_List.get(0).toMap();
temp_ser_line_item.put("Part_Line_Items",Part_Line_Items_List);
new_serv_list = list();
k = 0;
for each serv_list_merge in Service_Line_Items_List
{
if(k == 0)
{
new_serv_list.add(temp_ser_line_item);
k = k + 1;
}
else
{
new_serv_list.add(serv_list_merge);
}
}
Tax_Amount = Sub_total * tax_percentage * 0.01;
Grand_Total = Sub_total + Tax_Amount;
terrResp = zoho.fsm.getRecords("Territories");
terrId = terrResp.get("data").toMap().get("id");
//Create work order
createMap = Map();
createMap.put("Summary",summary);
createMap.put("Due_Date",due_date);
createMap.put("Contact",id);
createMap.put("Type","Service");
createMap.put("Billing_Address",Billing_Address_map);
createMap.put("Service_Address",service_Address_map);
createMap.put("Territory",terrId);
createMap.put("Service_Line_Items",new_serv_list);
createMap.put("Tax_Amount",Tax_Amount);
createMap.put("Grand_Total",Grand_Total);
response = zoho.fsm.createRecord("Work_Orders",createMap);
info response;
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
max
Latha Velu
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー