I have a question similar to other posts but it is slightly different.
I have a Epicor connector that returns an array based on a truck number. The array contains a list of values (Kit ID) that correspond to a Tulip table with that same value (Kit ID). I believe I can use the new query function to filter the table in the app. Since it is an interactive table the operator can then select the record and be directed to the appropriate app.
The problem I run into is getting the connector array data translated into something I can use in the query. The array returns 1600-1700 Kit ID’s (many of them repeating) I just need a list/string/etc that can be stored as a variable(or maybe an expression?) that the query can use.
are you familiar with the Array > To String Trigger Action?? based on what I’m understanding, this could help create the filter you’d like for your Query.
let us know if this helps in what you’re trying to build!!
So right where is says “Truck BOM” there is the array I get back. I need to understand how to join them with the delimiter. I’ll try a couple of options.
ahh OK, @MikeRousch. in the Trigger Action above, is Parts List by Truck Number being stored as a Variable or Array?? if it’s a Variable, could you try Array??
the dropdown you circled will populate with all the Arrays available in your app.
The problem is that MAP_TO_TEXT_LIST(Variable.Parts List by Truck Number, “Parts List”) is that that variable is not reading in the array option. I found a work around where I used an interactive table to create a variable that I can convert into an array, but I don’t think the function is working as designed. I am missing a “.Truck BOM” at the end of (Variable.Parts List by Truck Number, “Parts List”). It should be (Variable.Parts List by Truck Number.Truck BOM, “Parts List”). The work around allows this to happen but in a way I don’t fully understand.
