Search - Joel Lipman .Com

1. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... " + zoho.currenttime.toString("yyyy-MM-dd-HH-mm") + ".csv"; f_UploadCsvFile = l_Csv_File.toString(v_NewLineChar).toFile(v_UploadFilename); // // upload the file r_UploadResponse = zoho.workdrive.uploadFile(f_UploadCsvFile,v_WorkdriveFolderID,v_UploadFilename,FALSE,"my_workdrive_connection"); if(!isNull(r_UploadResponse.get("data"))) { // ...; Created on 11 September 2024
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... the file You may note that this generates a text file rather than a CSV, this is because our JS widget won't pack a CSV but it will pack text files. // // generate a CSV or TXT v_CSVFilename ...; Created on 25 March 2024
3. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // ...; Created on 29 March 2023
4. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
5. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... systems: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // ...; Created on 01 March 2023
6. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage = true; v_Cursor = ""; l_CsvFileRows = List(); // // start preparing ...; Created on 20 February 2023
7. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... Castle,England\n"; v_DataCSV = v_DataCSV + "11,General Dogsbody,\"Flat 8, House Corner, My Street\",Brummieland\n"; v_DataCSV = v_DataCSV + "64,Elephant Man,\"123 New Street,\nNew York City\",USA\n"; f_CSVfile ...; Created on 26 August 2021
8. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... commas v_NewCSVline = "\"" + v_ThisEventTime.toString("yyyy-MM-dd HH:mm:ss") + "\",\"" + v_ThisEventNote + "\""; l_NewCSVrows.add(v_NewCSVline); } // // generate CSV v_CSVFilename = "audit-log-" ...; Created on 16 June 2021