Checkbox module query

1

Hello Robert,

I was thinking about the “checkbox” module to filter or emit data in automation. Let me explain you the requirement in short.

Suppose we’ve got a trigger for an application and that trigger has numbers of fields (380+ fields) for a single record and out of those 20-30 fields are useful (which need to be a map in action assembly). Application API allows us to mention only fields which are required but I don’t want to do that because it would make assembly private. Here what I want:

I want to get all those fields to get through the ‘checkbox’ module and all the fields will appear in automation while configuring the trigger. Now I have the ability to check/uncheck those fields which need to be pass in API query. Something like that:

29-18_48_01

Let me know if I’m asking for right things or if it’s possible by any of the modules or assembly to improve the performance of the connector.

Thank you

2

Sorry, this doesn’t make any sense to me. What is the problem you want to solve?

3

we’ve an trigger assembly for DonorPerfect (Dev: dd07718a709045ad8bcb055c43a39616) which is working perfect and it’s specific to the customer, now they want new enhancement to pull other table data along with donor record. I’ve contacted with Donor support team to get API query, they helped me but asked me to throttle API response with limited fields. As I mentioned before, API query response with 380+ fields just for one records and most of them not useful. I want to pass all the fields but can be exclude in automation while configuring trigger. For example the query we’re passing currently in API:

  1. SELECT TOP 100 * FROM Donor;
    => This returns all the fields.

  2. SELECT TOP 100 contact_id, last_name, first_name FROM Donor;
    => But I want to use this query where I should have ability to pass fields from automation by ‘Checkbox’ or some other ways.

4

Currently there is a “Multi-Input Parameter” module that allows entering multiple items, so you would have to type in the field names instead of being able to pick them from a list. See assembly 5cd93c2a153d42c58c7b43cbd76781e0 in dev.apiant, which uses this control.

I will see about adding a multi-select list UI control like you describe. Might be something I can add next week.

1 Like
5

Thanks for the understanding and guidance. I’ll try this.

6

FYI, a new multi-select parameter module has been added for the next release that will do as you initially described:

image
image.png1676×1498 161 KB

The new release is probably two weeks away.

7

Nice! Is it available to use or have to wait for release?

8

I plan to install the new release into dev.apiant soon, hopefully in the next day or so.

But the new release is not compatible with other systems that aren’t yet upgraded, so I will lock the dev.apiant system so no content can be exported from it.

9

Understood, thanks for everything.

10

The new multi-select parameter module is available in the new system release:

Your devops needs to reboot the system twice after installing this upgrade. They need to wait until an error message appears in catalina.out before the second reboot.