Forum Discussion

hrender's avatar
hrender
New Contributor
7 years ago

Scheduled Task + File Poller guidelines

I have several legacy file-based interfaces I’m migrating to Snaplogic. Many of them involve polling for new input files on a scheduled basis, usually something like every 30/60/120 seconds. I’ve c...
j_angelevski's avatar
j_angelevski
Contributor III
2 years ago
Copy LinkReport

Hi Manzoor ,

Depending on your input data, if you have a flat object, you can make all of the NULL fields blank by using the following expression:

$.mapValues(val => val == null ? "" : val)

This will iterate over each value for each key in the input data and depending if the value is null, it will return an empty string otherwise it will return the original value.

 

Input data sample:

[
    {
        "msg": "Hello, World",
        "num": 1,
        "field2": null
    }
]

 

Output:

[
  {
    "msg": "Hello, World",
    "num": 1,
    "field2": ""
  }
]
  • petar_rajchinos's avatar
    petar_rajchinos
    New Contributor III
    6 years ago
    Copy Link

    Hi parvez.shaikh19,

    If there is a unique key in the excel and the SQL server table the easiest way to detect changes is using Diff snap (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438546/Diff). If that doesn’t help than you need to manually create logic for getting the rows from the excel and searching the row in the table. In order to make the search easier and faster you can hash each row (Digest.md5(col1+col2)) from the excel and do the same thing with the table rows and compare hashes instead of columns.

    Regards,
    Petar