Kaizen 105 Functions Integration Tasks and API Credits Part 1

Hello everyone!

Welcome back to another week of Kaizen!

In today's post, we will discuss functions, integration tasks, how they consume API and function credits.

In the next post, we will discuss connections, the difference between integration tasks and invoke URL in functions, how authentication happens for invoke URLs, and their credit consumption pattern.

What are functions in CRM?

A business involves multiple processes that cater to specific needs, like managing the sales pipeline, automating the flow of data between modules or different third-party systems, etc.

Zoho CRM gives you a wide range of options to achieve your business goals in the form of pre-defined functions under Setup > Developer Space > Functions. You can tweak these functions and associate them to workflows, blueprints, approval processes, circuits amongst many others, at just the click of a button.

While it is understandable that every business' needs are different, and the pre-defined functions, albeit very generic and most-commonly used, may not suit every business, Zoho CRM allows you to write your own functions specific to your needs.

More details on functions, here.

You can use Zoho's Deluge scripting language to write your own functions in a simple drag-and-drop function editor under Setup > Developer Space > Functions.

Integration tasks

We talked about how functions solve your business cases. How exactly do they do it?

Let's say you want to create a record in Zoho CRM using Functions. Instead of having to add values to every field the traditional way in web UI, functions have integration tasks that make working with records a lot easier as they act as API wrappers. These integration tasks help you make direct API calls without having to write code manually to handle API endpoints, HTTP methods, request parameters, or authentication mechanisms. What's more? They accept the input as function arguments in key-value pairs, much like JSON.

How are integration tasks beneficial to you?

When you use multiple Zoho products, data flow between them becomes much simpler and easier through integration tasks.

Your code becomes concise and easy to interpret.

As the integration tasks are essentially API wrappers, you do not have to worry about authorization as these integration tasks are considered as API calls triggered by the org's admin.

For today's post, let us discuss the function Converting a Sales Order to a Purchase Order, that uses integration tasks.

A gist of the code:

Use the getRecordById integration tasks to get the ID of the Sales Order you want to convert to a Purchase Order
Get the details of the product line items in the sales order, iterate through each of them, and add them to a map.
Put these in another map to be used in the Purchase Order.
Use the createRecord integration task and pass the new map to create a purchase order with the details from the sales order.

Here is the code:

Note that this function takes the soID(sales order ID) as the argument.

respMap = zoho.crm.getRecordById("Sales_Orders",input.soId.toLong());

productDet = ifnull(respMap.get("Product_Details"),"");

pdlist = List();

for each eachProd in productDet

{

productvalue = eachProd.get("product");

proid = productvalue.get("id");

proname = productvalue.get("name");

mp = Map();

mp.put("product",{"name":proname,"id":proid});

mp.put("quantity",ifnull(eachProd.get("quantity"),"0").toLong());

mp.put("list_price",ifnull(eachProd.get("list_price"),"0.0").toDecimal());

mp.put("discount",ifnull(eachProd.get("discount"),"0.0").toDecimal());

mp.put("total",ifnull(eachProd.get("total"),"0.0").toDecimal());

mp.put("net_total",ifnull(eachProd.get("net_total"),"0.0").toDecimal());

pdlist.add(mp);

}

paramap = Map();

paramap.put("Product_Details",pdlist);

paramap.put("Subject",ifnull(respMap.get("Subject"),""));

paramap.put("Contact_Name",ifnull(respMap.get("Contact_Name"),"").get("id"));

paramap.put("Account_Name",ifnull(respMap.get("Account_Name"),"").get("id"));

paramap.put("Owner",ifnull(respMap.get("Owner"),"").get("id"));

paramap.put("Sales_Order",ifnull(respMap.get("id"),""));

paramap.put("Terms_and_Conditions",ifnull(respMap.get("Terms_and_Conditions"),""));

paramap.put("Description",ifnull(respMap.get("Description"),""));

paramap.put("Adjustment",ifnull(respMap.get("Adjustment"),"0.0").toDecimal());

paramap.put("Discount",ifnull(respMap.get("Discount"),"0.0").toDecimal());

paramap.put("Tax",ifnull(respMap.get("Tax"),"0.0").toDecimal());

paramap.put("Shipping_Cuty",ifnull(respMap.get("Shipping_Cuty"),""));

paramap.put("Shipping_Code",ifnull(respMap.get("Shipping_Code"),""));

paramap.put("Shipping_Method",ifnull(respMap.get("Shipping_Method"),""));

paramap.put("Shipping_State",ifnull(respMap.get("Shipping_State"),""));

paramap.put("Shipping_Street",ifnull(respMap.get("Shipping_Street"),""));

paramap.put("Status",ifnull(respMap.get("Status"),""));

createResp = zoho.crm.createRecord("Purchase_Orders",paramap);

info paramap;

info createResp;

Here is the response:

This is the Purchase order created from the sales order.

I have associated this function to a workflow that converts a sales order to a purchase order, every time a sales order is created or updated.

How is authentication handled for integration tasks?

Functions with integration tasks are triggered by actions like workflows, blueprints etc. These triggers are org-wide and not restricted to specific sets of users. So, the integration tasks are executed as if the actions are done by the org’s admin.

API and Function Credits

Just like how APIs consume credits, integration tasks consume API credits, too.

The number of credits depends on the integration task you have used. For example, if you use the createRecord integration task, it consumes the same credits as the create records API. Similarly, the getRecordById integration task consumes the same credits as the Get Records API.

This is in addition to the function credits.

So, for the above function, the following are the various limits applied:

API credits - 2 - one each for getRecordById and createRecords integration tasks.
Function credits - 1

Where can you find the usage stats?

The API Dashboard and Functions Dashboard.

API Dashboard

Apart from API credit consumption, the API dashboard also gives you the details of the credits consumed by integration tasks.

The "Credits Usage" section shows you the credits specific to integration tasks. As you can see, out of the total available 56000 credits, 36 credits are consumed. Out of these 36 credits, 32 are from integration tasks.

The "Credits by Applications/Functions" pie chart gives you the credit consumption by each function or app.

When you click on one of them, you will see the details.

Functions Dashboard

The "Most Credits Consumed Functions" chart gives you the details of the functions that have consumed credits higher than most.

We hope you found this post useful. Next week, we will discuss Connections, invoke URLs and more.

Let us know what you think in the comments, or drop us an email at support@zohocrm.com.

Cheers!

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Shylaja S
Pablo Silva Osorio

Sticky Posts
Extension pointers for integrating Zoho CRM with Zoho products #8: Upload and manage Zoho Workdrive folders and files from within Zoho CRM
Keeping records on your customers and business prospects is essential for tracking data, conducting follow-ups, and running a business smoothly. When you use two separate applications, and store relevant data in each, checking and tracking data becomes
Extension pointers: Handle cases with personalized solutions using custom actions
In our last post, we detailed the steps involved in creating a custom action and the workflow from the developer and end user's side. Now let's look at a working example of how we can create a custom action and implement it in a Zoho CRM account to make
Extension pointers - Simple yet significant pointers #13: On change of field value for CRM variables
CRM variables provide global access to a variable across an entire extension. They also help in the storage of user-specific data provided by the user at the time of installation, which can later be fetched to perform data functionalities. Additionally,
Extension pointers: Extend end-user benefits and allow personalization by implementing extensions with custom actions
From our earlier post on custom actions, we know that we can create templated actions, share them with end users, and allow them to reuse those actions to achieve personalized outcomes. In this post, we'll look at how custom actions make it easy for users
Extension pointers - Simple yet significant pointers #12: Functions for Zoho CRM extensions
Functions are essential in achieving logical functionality for an extension. You can easily code your functions in Deluge using drag-and-drop tools to meet your requirements. How to create functions for Zoho CRM extensions in Sigma Go to Sigma and select