Lookup data from Handlebars template

Integrator.io
, , , ,
1

Hello,

We're throwing around some different design ideas for a project and one of the ideas would require retrieving configuration data stored with the record from a Handlebars template. Thing XML template being saved to FTP server.

This configuration data is an array of essential key/value pair records, something like this:

{
	"config": [{
		"name": "supplierSKUId",
		"value": "PW"
	}, {
		"name": "UOMQualifierID",
		"value": "UOMQID"
	}]
}

From our template, we'd like to do something like this:

<?xml version="1.0" encoding="UTF-8"?>

    
        TransferOrder
        {{timeStamp 'UTC'}}
        {{find "config", "name", "UOMQualifierID", "value", ""}}

That would yield

UOMQID

The signature of the helper would be:

{{find , , , , [, ]}}

That signature is getting a bit long, perhaps the find() helper could return an object and could be used in conjunction with a helper like getValue but one that took an object reference as a parameter, something like this:

{{getValue (find "config", "name", "UOMQualifierID") "value"}}

I'm sure if I thought about this longer I could think of more use cases and maybe some overloads to support those use cases, but you get the idea (hopefully) from this example.

My question: Is there a way to do this now?

Follow up question: If not, can we work with you to create this helper?

Regards,
Steve

2

Hi Steve,

There is no way currently to add custom helpers. I am unsure exactly what your output should be here, but would this handlebar work for you?

{{#each config}}
<{{name}}>{{value}}
{{/each}}

3

Thanks for the reply Orion.

I updated my post to so correct a missing parameter in my "find" helper examples, I also added a section on what I would expect to have returned. Your example will enumerate an array, I'm not looking for that, I want to find an object in an array and use one of it's properties in my template.

4

Hi Steve, if that is the case, where you can't just take out the config XML elements from your template and list all the elements in order of the config array using the #each helper, which would make a this output:

PW
UOMQID

If the above doesn't work for you, assuming this is for a custom flow and not an Integration App, you can add a JavaScript preMap hook to the import step to separate out the objects into the config array into their own key/value pairs, and use those directly in each corresponding element without a handlebar helper. There currently is no way to add a custom handlebar helper.

5

Hi Orion,

Thank you for the reply.

I don't want to do this in script, I'm looking for a template only solution. Hopefully my post here will get some attention and there can be consideration for adding this helper or something like it.

6

I believe these built-in helpers would also work for your use-case without needing a custom one, but I do also hope that at one point custom helpers will be configurable.

{{#each config}}{{#compare name '==' 'supplierSKUId'}}{{value}}{{/compare}}{{/each}}
{{#each config}}{{#compare name '==' 'UOMQualifierID'}}{{value}}{{/compare}}{{/each}}

7

Hi Steve, if that is the case, where you can't just take out the config XML elements from your template and list all the elements in order of the config array using the #each helper, which would make a this output:

PW
UOMQID

If the above doesn't work for you, assuming this is for a custom flow and not an Integration App, you can add a JavaScript preMap hook to the import step to separate out the objects into the config array into their own key/value pairs, and use those directly in each corresponding element without a handlebar helper. There currently is no way to add a custom handlebar helper.

8

Hi Orion,

Thank you for the reply.

I don't want to do this in script, I'm looking for a template only solution. Hopefully my post here will get some attention and there can be consideration for adding this helper or something like it.

9

I believe these built-in helpers would also work for your use-case without needing a custom one, but I do also hope that at one point custom helpers will be configurable.

{{#each config}}{{#compare name '==' 'supplierSKUId'}}{{value}}{{/compare}}{{/each}}
{{#each config}}{{#compare name '==' 'UOMQualifierID'}}{{value}}{{/compare}}{{/each}}