Deluge: от КП в Zoho CRM → превью в Sheets → файл в WorkDrive → вложение в CRM

info QuoteID;
// Получаем данные по Quote из Zoho CRM
Quote = invokeurl
[
	url :"https://www.zohoapis.eu/crm/v8/Quotes/" + QuoteID
	type :GET
	connection:"crm_zoho_dev"
];
Quote = Quote.get("data").toMap();
//
// Таблица 
Quote = invokeurl
[
	url :"https://www.zohoapis.eu/crm/v8/Quotes/" + QuoteID
	type :GET
	connection:"crm_zoho_dev"
];
Quote = Quote.get("data").toMap();
Subject = Quote.get("Subject");
Account_Name = Quote.get("Account_Name");
if(Account_Name.isNull() == false)
{
	Account_Name = Account_Name.get("name");
}
Contact_Name = Quote.get("Contact_Name");
if(Contact_Name.isNull() == false)
{
	Contact_Name = Contact_Name.get("name");
}
Owner = Quote.get("Owner").get("name");
Delivery_address = Quote.get("Delivery_address");
Ready_by_date = Quote.get("Ready_by_date");
Sub_Total = Quote.get("Sub_Total");
Valid_Till = Quote.get("Valid_Till");
Grand_Total = Quote.get("Grand_Total");
Tax = Quote.get("Tax");
Adjustment = Quote.get("Adjustment");
currency_symbol = Quote.get("$currency_symbol");
Quoted_Items = Quote.get("Quoted_Items");
info Quoted_Items;
row_data = list();
// Создаем список строк
// Заголовки для таблицы
header = Map();
header.put("Product Name","Product Name");
header.put("Description","Description");
header.put("Quantity","Quantity");
header.put("Price","Price");
row_data.add(header);
// Заполняем данными
resourceId = "m78m951ed261da6564fe898b2892823e9af51";
GrandTotal = 0;
for each  rec in Quoted_Items
{
	Product_Name = rec.get("Product_Name").get("name");
	Article = rec.get("Article");
	Color = rec.get("Color");
	Packaging = rec.get("Packaging");
	Fabric_model = rec.get("Fabric_model");
	Print_size = rec.get("Print_size");
	Product_size = rec.get("Product_size");
	Print_type = rec.get("Print_type");
	Quantity = rec.get("Quantity");
	List_Price = rec.get("List_Price");
	Total = rec.get("Total");
	Link = rec.get("Link");
	Parent_Id = rec.get("id");
	Preview = rec.get("Preview");
	for each  rec in Preview
	{
		fileId = rec.get("File_Id__s");
		info "fileId: " + fileId;
		File_Name__s = rec.get("File_Name__s");
		if(rec.get("File_Id__s") != null)
		{
			// Загружаем файл по fileId
			fileDownloadUrl = "https://www.zohoapis.eu/crm/v8/files?id=" + fileId;
			// Выполняем GET-запрос
			file = invokeurl
			[
				url :fileDownloadUrl
				type :GET
				connection:"crm_zoho_dev"
			];
			info file;
			file.setParamName("file");
			//
			header.put("x-filename",File_Name__s);
			header.put("x-parent_id","m78m95115e88cd68f4978895817486547edf4");
			header.put("upload-id",fileId);
			header.put("x-streammode","1");
			response = invokeurl
			[
				url :"https://upload.zoho.eu/workdrive-api/v1/stream/upload"
				type :POST
				parameters:file
				headers:header
				connection:"workdrive"
				content-type:"application/octet-stream"
			];
			info response;
			//
			resource_id = response.get("data").get(0).get("attributes").get("resource_id");
			info resource_id;
			Preview = "https://previewengine-accl.zoho.eu/image/WD/" + resource_id;
			//
		}
	}
	// 	Preview = "https://crmsandbox.zoho.eu/crm/devzn/specific/ViewAttachment?fileId=" + fileId + "&module=QuotedItems&fieldId=625426000000542577&parentId=" + Parent_Id + "&name=" + file + "&downLoadMode=default";
	Preview = "=IMAGE(\"" + Preview + "\";1)";
	info Preview;
	//
	row = Map();
	row.put("Product Name",Product_Name);
	row.put("Preview",Preview);
	row.put("Q",Quantity);
	row.put("Item Price",List_Price);
	row.put("Total Price",Total);
	row.put("Link",Link);
	row.put("Article",Article);
	row.put("Color",Color);
	row.put("Fabric / model",Fabric_model);
	row.put("Packaging",Packaging);
	row.put("Product Size",Print_size);
	row.put("Print Type",Print_type);
	row.put("Print Size",Print_size);
	row.put("Project name",Account_Name);
	row.put("Account manager",Owner);
	row.put("Delivery info",Delivery_address);
	row.put("Ready by date",Ready_by_date);
	rowsData = List();
	rowsData.add(row);
	queryData = Map();
	response = zoho.sheet.createRecords(resourceId,"Sheet2",rowsData,queryData,"zoho_sheet");
	// 		info response;
}
//
paramMap = Map();
paramMap.put('method','workbook.copy');
paramMap.put('resource_id',resourceId);
paramMap.put('workbook_name',Subject);
paramMap.put('parent_id','hmb7xd57420ae63934e46991c703d67eae9de');
paramMap.put('copy_lock_settings','true');
response = invokeurl
[
	url :"https://sheet.zoho.eu/api/v2/copy"
	type :POST
	parameters:paramMap
	connection:"zoho_sheet"
];
info response;
workbook_url = response.get("workbook_url");
info workbook_url;
//
formData = Map();
formData.put("attachmentUrl",workbook_url);
formData.put("title",Subject);
response = invokeurl
[
	url :"https://www.zohoapis.eu/crm/v7/Quotes/" + QuoteID + "/Attachments"
	type :POST
	parameters:formData
	connection:"crm_zoho_dev"
];
info response;
//
if(response.get("code").contains("DUPLICATE_DATA") == true)
{
	result = response.get("message");
}
else
{
	result = "Files Generated";
}
//
paramMap = Map();
paramMap.put('method','range.content.clear');
paramMap.put('worksheet_name','sheet2');
paramMap.put('start_row',2);
paramMap.put('start_column',1);
paramMap.put('end_row',50);
paramMap.put('end_column',17);
response = invokeurl
[
	url :"https://sheet.zoho.eu/api/v2/" + resourceId
	type :POST
	parameters:paramMap
	connection:"zoho_sheet"
];
info response;

Важные переменные/идентификаторы

Зачем так делать (практический эффект)