User Activity

I'm trying to replace the REST Get snaps in my pipelines with the Http Client snap but the response I'm getting is formatted differently. With the Rest Get snap, the JSON response is formatted as a list so I can subset it using $entity.data notation:...
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...
Kudos given to