This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a triggered task that pulls data from a database and formats the JSON to be returned by an http request.I added a parameter called 'dataset_name' so users making an api call can select just one record from the database: I pass the value '_data...
I'm trying to develop a pipeline that queries two (or more) database tables, converts them to CSV, compresses them to a single archive and writes them to and S3 bucket. I have a working pipeline for a single table:But what I'd like to do is have mult...
I'm trying to delete rows from my database when their id's aren't in the response document returned from an api query. Currently, my pipeline looks like this:If there is an ID value in the SQL Server table that is not in the REST response document, I...
I have a document like this: [
{
"first": ["1", "2"],
"second": "a"
},
{
"first": ["3", "4"],
"second": "b"
}
] And I'm trying to convert it to a table like this: FirstSecond1a2a3b4bI'm thinking I need to use the "map" or "m...
I have one document structured like this: FirstNameLastNameTitleAnnSmithMsJuneJonesMrsSamJohnsonMrsAnd a second document like this: LabelValueMyEvent8/21/23I'm trying to merge them together to get a final product like this: FirstNameLastNameTitleValu...
That's great. I didn't realize you could write to S3 with the ZipFile Write snap. As a bonus, is it possible to make the file name today's date? I tried:'s3:///my-data-warehouse-backup@s3.us-west-1.amazonaws.com/' +Date.now().toString().replaceAll(":...
Thanks Aleksandar. Is there a resource to learn this notation and how to use it in Snaplogic?
If my JSON were formatted like this, how would I adapt that expression?
{
"id": "1",
"subjects":
[
{
...
