Plytix Delta Flow Help

Comments

1 comment

  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Joseph you could try something like this. This doesn't use the "Delta" option and would instead use the "All" option. It gets the current timestamp for 9am CST and 12pm CST and adds those to the filter criteria.

    {
      "filters": [
        [
          {
            "field": "modified",
            "operator": "gte",
            "value": "{{dateFormat "YYYY-MM-DDTHH:mm:ss.SSSSSS" (dateAdd (timestamp "YYYY-MM-DD" "America/Chicago") "32400000") "YYYY-MM-DDTHH:mm:ss.SSS[Z]"}}{{dateFormat "Z" (timestamp) "YYYY-MM-DDTHH:mm:ss.SSS[Z]" "America/Chicago"}}"
          },
          {
            "field": "modified",
            "operator": "lte",
            "value": "{{dateFormat "YYYY-MM-DDTHH:mm:ss.SSSSSS" (dateAdd (timestamp "YYYY-MM-DD" "America/Chicago") "43200000") "YYYY-MM-DDTHH:mm:ss.SSS[Z]"}}{{dateFormat "Z" (timestamp) "YYYY-MM-DDTHH:mm:ss.SSS[Z]" "America/Chicago"}}"
          },
          {
            "field": "attributes.website",
            "operator": "eq",
            "value": "website2"
          }
        ]
      ],
      "attributes": [
        "attributes.shopify_title",
        "attributes.handle",
        "attributes.title_override_checkbox",
        "attributes.title_override",
        "attributes.sjstatus",
        "attributes.product_description",
        "attributes.description_override_checkbox",
        "attributes.descriptionoverride",
        "attributes.item_image_item_image2",
        "attributes.image_src",
        "attributes.image_override_checkbox",
        "attributes.product_type",
        "attributes.brand_name",
        "attributes.tags",
        "attributes.pro_benchmark_retail",
        "attributes.map_pricing",
        "attributes.usemappricing",
        "attributes.cost_per_item",
        "attributes.suggested_retail",
        "attributes.upc_code",
        "attributes.inventory_management",
        "attributes.weight",
        "attributes.variant_weight_unit",
        "attributes.inventory_id",
        "attributes.mro_supreme_variant_id",
        "attributes.variant_inventory_policy",
        "attributes.published",
        "attributes.variant_taxable",
        "attributes.attributes",
        "attributes.attributes_override",
        "attributes.attributes_override_checkbox",
        "attributes.about_this_item",
        "attributes.about_this_item__more_information_checkbox",
        "attributes.about_this_item__more_information_override_1",
        "attributes.shelf_pack",
        "attributes.shelf_pack_quantity",
        "modified"
      ],
      "pagination": {
      "page": {{add export.http.paging.page 1}},
       "page_size": 100
      }
    }
    }

    0

Please sign in to leave a comment.