Designing and Running Pipelines

Question Regarding Scheduled Task cron First Tuesday of the month

I have a pipeline that needs to run on the first Tuesday of every month. Looking at the details indicates that the scheduled task should execute as expected, see below… However, the task never executed. Any insight as to why this task did not execut...

Downloading and Uploading XMLs

I’m working on an integration in which i download a XML from endpoint A then i need to post this xml file to endpoint B, passing it as a file that goes into form-data. How to create the XML file from the response i get from endpoint A? While using P...

REST API ERROR 503 error keeps on increasing even if input is one

Hi All, I used a REST API with pagination where there was only one input but due to server unavailability , I got an 503 error. But my doubt is why the error was keep on increasing. Since the error was keep on increasing i had to stop the pipeline. C...

Worksheet Writer - Cannot lookup a property on a null value

Hello! I am having an issue with the Worksheet Writer snap. As you can see below the Mapper snap has output value for $date_of_this_report field but when I map this to the Worksheet name, the snap returns ‘Cannot lookup a property on a null value’ e...

Resolved! Generating a unique (but consecutive) ID that resets daily

My end user wants a unique ID that consists of “YY” + “DDD” + 12-digit consecutive number that resets to 1 each day - so it would be: 000000000001 000000000002 000000000003… The date parts are cake, but the consecutive number is throwing me for a loo...

Resolved! Email sender - Change table row color based on value

Hi snaplogic experts, is it possible to change table row in email body based on current value ? in my example i retrieve email with values - but is it possible to mark whole row as green, if revenue is higher as e.g. $5000? just to make email readab...

Dynamically setup dashboard execution label from triggered task

Hi Snaplogic Gurus, Good day, is there a way to set the execution label using triggered task FYI, the executing pipeline that I would like to dynamically set the execution label is the parent pipeline this is a common pipeline then accepts a JSON obj...

Resolved! To fetch value from group by output based on different values of one field

Hello Community, I want to fetch ESTVERSION value after performing the group by REQUESTNUM based on condition as below: If all records having STATUS=‘ESTIMATED’ then max(ESTVERSION) else if anyone STATUS=‘ACCEPTED’ then that ESTVERSION must be fetche...

SnapLogic - Integration Nation

Forum Posts

Question Regarding Scheduled Task cron First Tuesday of the month

Downloading and Uploading XMLs

REST API ERROR 503 error keeps on increasing even if input is one

Worksheet Writer - Cannot lookup a property on a null value

Resolved! Generating a unique (but consecutive) ID that resets daily

Resolved! Email sender - Change table row color based on value

Dynamically setup dashboard execution label from triggered task

Resolved! To fetch value from group by output based on different values of one field

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error