Search - Joel Lipman .Com

1. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the ...; Created on 22 January 2022
2. 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
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... = 12345000000678901; v_Template = zoho.sign.getTemplateById(v_TemplateID); v_OutputMessage = ""; // // get the Action ID for SIGN v_SendActionID = 0; if(!isNull(v_Template) && !isNull(v_Template.get("templates"))) { // ...; Created on 06 August 2024
4. 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
5. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... create task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition ...; Created on 14 May 2024
6. 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
7. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... true which will automatically send it and mark it as sent. As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff ...; Created on 07 March 2024
8. 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
9. 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
10. 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
11. 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
12. 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
13. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... response event, terminal.reader.action_succeeded, then view event details ******************************************************************************* */ // // initialize m_Blank = Map(); m_Response ...; Created on 16 March 2023
14. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. ...; Created on 06 March 2023
15. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... dof f/1.8 f/1.4 f/2.0 f/2.8 Style of Art/Film Same image again but let's try some of these keywords out: Abstract Action Painting Alien Art Nouveau Baroque Bokeh Clip Art Collagraph Comic Conceptual Cubism Cyberpunk Dazzle Dream-like Engraving Etching Fantasy Fauvism Film ...; Created on 11 February 2023
17. 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
18. 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
19. 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
20. 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