Forum Discussion

snapation6713's avatar
snapation6713
New Contributor III
2 years ago
Solved

Snaplogic Rest Post Snap: Failing with Invalid input JSON

I have a Json Generator snap that contains the following snippet: { "filterGroups": [ { "filters": [ { "propertyName": "lastmodifieddate", "operator": "GT", "value":"2024-04-18T18:21:27.255Z" } ] }...
  • snapation6713's avatar
    snapation6713
    2 years ago

    This error message went away when I used parameters to pass the datetime.  I get the value from a query then I create the json using a script snap with this snippet:  


                // Set propertyName and value from pipeline properties
                filter.put("propertyName", $_dttmColumn);
                filter.put("operator", "GT");
                filter.put("value", $_max_dttm);  
    where max_dttm contains the datetime value.
snapation6713's avatar
snapation6713
New Contributor III
2 years ago
Copy Link

This error message went away when I used parameters to pass the datetime.  I get the value from a query then I create the json using a script snap with this snippet:  


            // Set propertyName and value from pipeline properties
            filter.put("propertyName", $_dttmColumn);
            filter.put("operator", "GT");
            filter.put("value", $_max_dttm);  
where max_dttm contains the datetime value.