Search - Joel Lipman .Com

1. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... the Stored Procedure and the SELECT at the same time; this meant the report would say the process failed but when I check the logs, it successfully ran the stored procedure (updating both tables). ...; Created on 04 November 2011
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ype") == "RequestSigningSuccess") { v_DocStatusSuffix = "SIGNED"; b_UpdateRecipient = true; v_RecipientEmail = m_Notification.get("performed_by_email"); } else if(m_Notification.get("operation_ ...; Created on 06 August 2024
3. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at least 10'000: // v_Counter = 0; l_Loop ...; Created on 31 July 2024
4. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... :v_Endpoint type :GET headers:m_Header connection:"my_connection" ]; //info r_Analytics; // // parse response if(r_Analytics.get("status") == "success") { m_ResponseData = ifnull(r_Analytics.get("data"),Map()); l_DataSources ...; Created on 02 July 2024
5. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.appname, "Quote", m_QuoteRecord, m_Blank, "my_creator_connection"); // // SUCCEEDS: with r_Create = ,"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community ...; Created on 04 October 2023
6. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... in the hopes that your browser will just begin downloading it (failing this it will open up in the browser and staff member will need to be instructed on how to 'File > Save As...'): // // if successful if(r_Attachment.get("code") ...; Created on 02 October 2023
7. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... This should yield something as follows: { "code": 0, "message": "success", "data": { "payment_terms": [ { "payment_terms_id": "123456000000000123", "payment_terms": ...; Created on 06 July 2023
8. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... d Successfuly!!! ID: "; info v_PaymentIntentID; // // Hand Off Payment Intent to Reader v_ReaderHandOffEndpoint = "https://api.stripe.com/v1/terminal/readers/" + v_StripeTerminalID + "/process_payment_intent"; m_PaymentHandOffPara ...; Created on 16 March 2023
9. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... the name field. Create a sample record with just the name field (placed at top of request) and comment out the other fields from the rest of the request to test. Once you have successfully created a ...; Created on 08 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... v_WorkArea, MonitorWorkArea v_GuiYpos := v_WorkAreaBottom - v_GuiHeight - 2 ; Output file names v_ProcessID := DllCall("GetCurrentProcessId") v_FileName_Errors := "Errors_" v_ProcessID v_FileName_Success ...; Created on 16 January 2023
11. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application Upon successful authentication, ...; Created on 17 October 2022
12. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; What? An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing ...; Created on 07 April 2022
13. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... workflow which does the clever bit in Zoho Creator: Go to Workflow > Form Workflows > New Workflow Choose the form > Run when Created or Edited > Trigger on Successful form submission > and name it ...; Created on 31 March 2022
14. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... = ifnull(m_Webhook.get("record").get("Lead_Status"),""); } // // if user profile is not allowed to make this change m_Output.put("status","success"); if(v_LeadStatus != "") { if(l_DisallowedProfiles.contains(v_UserProfile) ...; Created on 11 February 2022
15. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... successful...: For this strange fix, I'm going to list step by step but using the "Google Chrome" web browser: Login to ZohoCRM > Setup > Templates > Inventory Click on the name of the problematic ...; Created on 25 January 2022
16. 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 ...; Created on 22 January 2022
17. 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
18. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... , p_ContactID, r_DownloadResponse); if(r_AttachResponse.get("code")=="SUCCESS") { v_OutputMessage = v_OutputMessage + "Generated and attached file to CRM record. "; } // // to generate and send v ...; Created on 21 October 2021
19. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... My use-case scenario here is that while I could upload the link from Creator to eBay's Picture Services successfully, Shopify would not accept any links I gave it. Why not use the links that eBay returns? ...; Created on 17 October 2021
20. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... if successful then read the response if(r_ResponseXML.contains("Success")) { // // init l_JSONItems = List(); // // parse the data v_MainNode = "ActiveList"; x_MainNode ...; Created on 13 October 2021