Skip to main content

Hi,

So I have an external product catalogue and I am able to use the Webrequest node to GET an updated Product list from my external product manager. 

essentially what I want to do from there is take this returned array, verify it for existing products and then if they don’t exist POST a new product to allow for automated product updates.

Now I have my GET setup with no issues and I have created a JSON Parser to be able to reference back to this but I need some help getting from here to i guess mapping this array to product fields then validating them to see if they exist.

once I know they don’t exist then I believe another Web node to Post these back to Freshservice.

Here is a glimpse of my Json parser to give some info:
 

 

If anyone has some best practice ideas or maybe just recommendations for managing this I would appreciate it.

Expression in a condition maybe 

 

regexMatch(‘{{placeholder of the array}}’,’value to check’) That will give you a true or false

You can do more advanced if you know a bit about regex

 

Could be that you need to remove some characters from the placeholder before 

 

{{placeholder of the array | remove: ‘,’ | remove: “’” | remove: ‘”’ }}

That will remove  , and ‘  and “ 

 

 

 


Reply