Search - Joel Lipman .Com

1. MySQL Transactions in PHP: / MySQL /; ... changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ...; Created on 14 December 2016
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... _ if(!isNull(v_Template.get("templates").get("actions"))) { // get the actions l_Actions = v_Template.get("templates").get("actions").toList(); for each m_Action in l_Actions { if(m_Action.get("action_type") ...; Created on 06 August 2024
3. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... = l_LoopInner.toList(); // 3 actions so far // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4997 But the following counts as 1 statement ...; Created on 31 July 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... */ // // set your own REST API endpoints for the webhooks here (we are only checking order update or inventory level update) v_CrmOrderUpdateWebhook = "https://www.zohoapis.com/crm/v2/functions/fn_shopify_webhook_orderupdate/actions/execute?auth_type=apikey&zapikey=1003.aaaabbbbccccddddeeeeffff00001111.22223333444455556666777788889999"; v_CrmInventoryLevelWebhook ...; Created on 22 April 2024
5. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... "Tickets" under "Module" for the Rule Name, I called mine "Tickets - On Create or Edit" Execute On: Create, Edit, Customer Reply No Criteria Under 4. Actions, I click on "All Actions" and select "Custom ...; Created on 05 December 2023
6. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... I've called it "zcrm". Standard Call for Module Record Count: v_PerPage = 200; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count"; r_MaximumCount = invokeurl [ url :v_Endpoint type ...; Created on 14 November 2023
7. Zoho CRM: Change System Field Length: / Zoho /; ... the "Lead Conversion Mapping" page, mapping it, and then testing by converting a lead to a deal. Actions Login to ZohoCRM > Setup > Modules and Fields Click on the "Deals" module (or whichever module ...; Created on 19 June 2023
8. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html - GetOrderTransactions Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/GetOrderTransactions.html - ...; Created on 27 April 2023
9. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... on "Deploy to Production" Select what actions to deploy (the "Ask ChatGPT") and then click on "Deploy" All done? Now Test! Login/Reload ZohoCRM Click on "Ask Zia" Type the "Ask ChatGPT" ...; Created on 06 March 2023
11. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... of field "Deal_Ref" from the ZohoSign Document Request v_DealRef = ""; if(!isnull(r_RequestDetails.get("requests"))) { if(!isnull(r_RequestDetails.get("requests").get("actions"))) { l_Actions ...; Created on 17 October 2022
12. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... = "https://zohoapis.com/crm/v2/settings/inventory_templates/" + v_TemplateID + "/actions/print_preview?record_id=" + p_QuoteID + "&print_type=pdf"; f_FileRequest = invokeurl [ url :v_Url ...; Created on 18 August 2022
13. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work despite being as per the documentation (see ...; Created on 17 August 2022
14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Another REST API CRM function which generates an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToke ...; Created on 31 March 2022
15. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... XML of a GetItemTransactions request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you ...; Created on 22 January 2022
16. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
17. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... = ""; v_AccessToken = ""; r_Response = getUrl("https://www.zohoapis.com/crm/v2/functions/fn_api_getxeroaccesstoken/actions/execute?auth_type=apikey&zapikey="); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken ...; Created on 10 January 2022
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = "Unknown"; l_SoapActions = List(); if(!isnull(m_Payload.getJSON("headers"))) { l_SoapActions = m_Payload.getJSON("headers").getJSON("soapaction"); for each v_SoapAction in l_SoapActions { l_SoapActionParts ...; Created on 20 September 2021
19. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... m_Record.toString(); } Without a regex solution and the replacement back to commas then the above outputs: Actions Do you want to get rid of the annoying escaped double-quotes ...; Created on 26 August 2021
20. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... + v_LineItemTotalVat; v_Total = v_Total + v_LineItemTotal; } // // other actions you want to do after all quotes looped through // } Save your function and click on "Done" ...; Created on 06 December 2020