Search - Joel Lipman .Com

1. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; What? This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went ...; Created on 02 February 2021
2. Zoho Deluge - Counting in a Map dataType: / Zoho /; What? A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can ...; Created on 02 September 2019
3. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their ...; Created on 25 October 2013
4. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
5. Joomla field types clear my html: / Joomla /; What? Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS ...; Created on 09 August 2012
6. Returned a data type that is not valid: / Transact-SQL /; Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during ...; Created on 06 January 2011
7. MySQL Data Type Reference Table: / MySQL /; A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...; Created on 15 February 2010
8. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... GET ZOHO BOOKS TAX IDs ---------------------- m_Taxes = Map(); r_Taxes = invokeurl [ url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; for ...; Created on 18 September 2023
9. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... type: GET ]; r_Download1.setParamName("file"); l_Downloads.add(r_Download1); r_Download2 = invokeUrl [ url: "https://www.africau.edu/images/default/sample.pdf" type: GET ...; Created on 20 July 2023
10. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a ...; Created on 06 July 2023
11. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... = "12345678901"; r_PaymentTerms = invokeurl [ url :"https://books.zoho.com/api/v3/settings/paymentterms?organization_id=" + v_BooksOrgID type :GET connection:"abzohobooks" ]; info r_PaymentTerms; } ...; Created on 06 July 2023
12. Zoho CRM: Change System Field Length: / Zoho /; ... record to an opportunity (or Deal) record. If you are using custom fields, then just ensure that the data type and field lengths match. In this case, they are system fields for the Postal Code which ...; Created on 19 June 2023
13. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; ... Unless you can monitor when these type of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name ...; Created on 12 June 2023
14. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory ...; Created on 04 May 2023
15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... v_OrderDate); info p_eBayOrderRef; // // get books tax rates m_Taxes = Map(); r_Taxes = invokeurl [ url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"joel_books" ]; if(!isnull(r_Taxes.get("taxes"))) { for ...; Created on 27 April 2023
16. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... to eBay:"; //info x_Params; // // send the request XML as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; //info "Respons ...; Created on 29 March 2023
17. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = invokeUrl [ url: "https://www.zohoapis.com/crm/v3/settings/business_hours" type: GET connection: "mycrmconnection" ]; info r_OrgDetails; Yields something like { ...; Created on 28 March 2023
18. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... // build up request v_Endpoint = "https://api-eu.dhl.com/track/shipments?trackingNumber=" + v_TrackingNumber; // // send request r_ShipmentDetails = invokeurl [ url: v_Endpoint type: GET headers: ...; Created on 21 March 2023
19. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save ...; Created on 06 March 2023
20. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // specify only the active list m_ActiveList = Map(); m_ActiveList.put("Include",true); m_ActiveList.put("ListingType","FixedPriceItem"); m_ActiveList.put("Sort","ItemID"); // // ...; Created on 01 March 2023