Search - Joel Lipman .Com

1. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; What? I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but ...; Created on 22 February 2019
2. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header ...; Created on 26 October 2011
3. Crystal Reports: Exporting to Excel omits column headers: / Excel /; If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions ...; Created on 03 June 2010
4. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... to new browser tab m_Response = Map(); m_Response.put("Content-Type","text/html"); m_Response.put("status_code",200); m_Header = Map(); m_Header.put("Content-Disposition","inline;"); m_Response.put("headers",m_Header); m_Response.put("body",v_BodyHTML); } else { ...; Created on 04 November 2024
5. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = invokeurl [ url :v_Endpoint type :GET headers:m_Header connection:"my_workdrive_connection" ]; info r_TeamFolderInfo; The one to rule them all // ====================== // get folder ...; Created on 11 September 2024
6. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... + v_ZA_ViewID + "/data"; // // send request r_PurchaseOrders = invokeurl [ url :v_Endpoint type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse ...; Created on 09 July 2024
7. 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
8. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... = zoho.encryption.hmacsha256(v_ClientSecret,v_Data,"base64"); // // retrieve Shopify's Hmac SHA256 from the header v_ShopifyHash = ""; if(m_Payload.get("headers") != null) { if(m_Payload.get("headers").get("x-shopify-hmac-sha256") ...; Created on 22 April 2024
9. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with ...; Created on 05 December 2023
10. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... r_WorkdriveUpload; if(!isNull(r_WorkdriveUpload.get("data"))) { // // set permissions to public and visible m_Headers = Map(); m_Headers.put("Accept","application/vnd.api+json"); for each r_Data ...; Created on 05 December 2023
11. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... " + v_AccessToken); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCal ...; Created on 27 April 2023
12. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 29 March 2023
13. 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
14. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = " https://api.stripe.com/v1/terminal/locations"; // // set Stripe header m_Headers = Map(); m_Headers.put("Authorization","Bearer " + v_StripeCustomerKey); // // default to balance due on this Invoice v_AmountToPay ...; Created on 16 March 2023
15. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... // send request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode" ...; Created on 06 March 2023
16. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall = "GetMyeBaySelling"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // ...; Created on 01 March 2023
17. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall = "GetOrders"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // ...; Created on 28 February 2023
18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... :POST parameters:m_GraphQl.toString() headers:m_Header ]; //info r_GetProductVariants; // // parse the response if(r_GetProductVariants.get("data") != null) { if(r_GetProductVariants.get("data").get("productVariants") ...; Created on 20 February 2023
19. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == ...; Created on 13 February 2023
20. ZohoCRM: Import Attachments: / Zoho /; ... Add, &Reload App, Restart Menu, FileMenu, Add, E&xit, CloseMe Menu, HelpMenu, Add, &Help..., AboutGUIShow Menu, MainMenu, Add, &File, :FileMenu Menu, MainMenu, Add, &Help, :HelpMenu v_ListViewHeaders ...; Created on 16 January 2023