... ID which has to be unique as you may have many files called "image001.jpg" but for other records.
Parent Id: The CRM Record ID you are going to attach the file to (eg. "zcrm_123450000000000123456").
...
... this returns something like the following (I've reduced the 200 records to about 6 of them):
{
"data": [
{
"Currency": "EUR",
"id": "123456789000000001"
},
{
"Currency": ...
... r_Response;
// yields: }
info r_Response.get("item");
// yields: "item_id": "2124100000000081031", ....
info r_Response.get("item").get("item_id");
// yields: Value is empty and 'get' function cannot ...
... be null) and in format DDMMYYYY:
-- Derived column task 1: Replace 'Date'
TRIM(Date) != "" ? TRIM(Date) : "00000000"
-- Derived column task 2: Add as new Column 'DC_Date'
-- (note this is a separate ...
... TOP 1
'' AS Name,
CONVERT(uniqueidentifier,'00000000-0000-0000-0000-000000000000') AS ItemID
FROM
ExecutionLogStorage
) AS d1
ORDER BY d1.Name ASC
Additional Modifications:
For ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.