Tag incoming records to the Data store?

Questions
1

Just wondering how to easily tag incoming records to the Data store (Add/Replace) as “new” for new records that are added and “update” for existing records that are overwritten? Do I need another module to create the logic or can it be achieved without? The module prior is the HTTP (make a request) which is extracting the data from a website. Many thanks for your assistance-

3

Welcome to the Make community!

Well, as a “best practice”, you should have columns for “Created Date” and “Last Modified Date”.
That way you can tell if a record is new if both fields are equal.

Hope this make sense! Let me know if there are any further questions or issues.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

4

Hi Sam- yes the data I’m grabbing actually has createdOn and updatedAt fields and the Data structure has these corresponding fields. I’m trying to tag the data bundles with New and Update (or similar) accordingly so I can split them at a router further down the scenario. New bundles add a record to the Data store and Updates overwrite existing records. I just can’t figure out how to keep the data bundles going through to the router with a tag on them to split them into New and Update? Many thanks for your assistance-
Best regards,
Des

5

How does your scenario currently look like?

To allow others to assist you with your scenario, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are extremely important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

  • the full scenario,
  • the zoomed in section of the scenario that you are referring to (if your scenario is huge),
  • a full scenario run/execution (showing output “speech” bubbles),
  • any error messages,
  • individual module fields,
  • relevant filter settings (conditions), and
  • each module’s output bundles
  • any external services (spreadsheet headers, sample data, regex101.com, etc.)

You can upload images here using the Upload icon in the text editor:

We would appreciate it if you could upload screenshots here instead of linking to them outside of the forum. This allows us to zoom in on the image when clicked, and avoid tracking cookies from third-party websites.

Sharing these details will make it easier for others to assist you.

6

Hi Sam- sorry I haven’t come back to you. I’ve been trying to solve other issues in my HTTP module which I might have to create another post about to see if I can solve that one first. Thanks again for your assistance-