... you can lock it down to just the scopes you need.
void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID)
{
v_OrderID = ifnull(input.p_OrderID,0).toLong();
/* *******************************************************************************
Function: ...
... void fn_Tickets_OnCreateEdit(int p_Ticket)
Label: Fn - Tickets - On Create or Edit
Trigger: Off a workflow when a ticket is created or modified
Purpose: Pushes the tickets attachments ...
...
void fn_Joel_Test()
{
/***
- tried with getUrl() but this doesn't work.
- has to be an invokeUrl
- set param name required
- if file comes from a Creator form, no InvokeURL needed
c_Form ...
... and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. ...
... clients set their due dates differently.
How?
The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are.
void fn_ReturnCurrentPaymentTerms()
{
v_BooksOrgID ...
... create map of line items and created SO (fix to invoice only generated on edit)
Date Modified: 2023-03-29 (Joel Lipman)
- If an eBay order comes through as cancelled, then void the sales order, ...
... (in other words, not alphabetical, numerical, or completely random order):
void JoelLipman.fn_SetStaffUsualShift()
{
//
// build a standard usual shift subform from CRM
r_OrgDetails = invokeUrl
...
... the modified records of a day and ensure that the data in Zoho is the same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself:
void ...
... this one "jl_recruit".
The Deluge code for workflow
/* *******************************************************************************
Function: void fn_AB_AssociateVacancy2Candidate(int ...
... ces" i2 ON i2."Invoice ID" = ii2."Invoice ID"
GROUP BY i2."Invoice ID"
) iquantity ON iquantity."Invoice ID" = inv."Invoice ID"
WHERE inv."Invoice Status" NOT IN ( 'Draft' , 'Void' )
GROUP BY ...
... next step.
STEP 4: THE REST
A Zoho Flow would submit the request ID and document ID as part of a map to the following function:
void fn_SignDataAndAttach(int v_RequestId, int v_DocumentId)
{
//
// ...
... in l_SearchResults
{
// check that there is an ID on this record to avoid looping through error messages
if(!isNull(r_Result.get("id")))
{
// do stuff to each record...
info r_Result.get("id");
}
}
//
// ...
... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function.
How?
If we're not going to use loops, then the next best thing ...
... > Select the template with this issue
Click on the "Edit HTML" icon in the top right of the editor:
Find the code "page-break-inside"
Change this from "avoid" to "auto":
And optionally, ...
... can use the following code, note that the parameter is the eBay Item ID:
void API.fn_eBayQuery_GetItemTransaction(int p_ItemID)
{
/*
Function: fn_eBayQuery_GetItemTransaction()
Input: ...
... : "gid://shopify/ProductImage/23456789012345"
}
}
This next version is a more generic form of the above function uploading the photo to Shopify:
void API.fn_ShopifyQuery_UploadPhoto(int p_ProductI ...
... It then outputs a JSON list as a response and the total record count:
void API.fn_ShopifyQuery_GetActiveProducts()
{
m_Header = Map();
m_Header.put("Content-Type","application/json");
//
// ...
... notification preferences are setup. This one didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked.
void API.fn_eBayQuery_GetNotificationPreferences()
{
/*
...
... this example, I will leave this as "void")
for Arguments
Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.