Search - Joel Lipman .Com

1. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... based on the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to execute the stored procedure, we use ...; Created on 04 November 2011
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... compare our hash vs the received hash if(v_VerifyHash == v_ShopifyHash) { m_ResponseHeader.put("status_code",200); } // // respond return ; The Code Snippets: The Shopify Inventory Level Updat ...; Created on 22 April 2024
4. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: ...; Created on 25 March 2024
5. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... number "OrgId" there Note this down for later use Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the "Home" level Click on the cog icon in the top-right for "Settings" ...; Created on 05 December 2023
6. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... or Access You should be in "My Folders" (left sidebar) Create a folder, I'm calling mine "Email Signature Images" Within that folder, create another folder called "_Global". At the same level, create ...; Created on 05 December 2023
7. Zoho Books: System Values Maps: / Zoho /; ... that for the below, I recently updated this article (2024-05-21) due to the API domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho ...; Created on 07 November 2023
8. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong()); m_CreateBooksItem.put("initial_stock",v_Quantity.toLong()); m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal()); m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...; Created on 04 May 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... StaticAlias) - Resolved fix of inventory adjustment level (Error:9205:Insufficient Stock) - Resolved fix of overpaid amount (Include Shipping Cost in SO) Date Modified: 2023-03-16 (Joel ...; Created on 27 April 2023
10. 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
11. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here is you'll find them in the settings; so check that ...; Created on 28 March 2023
12. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023
13. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... level or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? ...; Created on 01 March 2023
14. 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
15. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than ...; Created on 20 February 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Eye-Level Shot puts a massive eye on the picture???) Cinematic Still Shot Full-Body shot Headshot from chest up Portrait Knolling Satellite View Subject «This is the actual subject that ...; Created on 11 February 2023
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... function that can return the ebay URL of the image. Done High Level Overview Create a REST API CRM function Get Zoho CRM to create a Zoho Creator record by passing it the Inventory ID Get ...; Created on 31 March 2022
18. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... } } } } For anyone interested in the GraphQL to query using the inventoryLevel connection, try the following to get the Locations: v_GraphQl = " } } }"; Then usi ...; Created on 14 February 2022
19. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status ...; Created on 11 February 2022
20. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; 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 22 January 2022