Quote from erik.haug on July 11, 2022, 12:26 pm

We are using Custom API's to return On Premise data based on a Filter defined by a SharePoint Field.  For this example I am using a custom API to return Invoices over the last 14 days.  The query I use must be GetInvoices:CustomerNumber.  The query parameter maps CustomerNumber to a SharePoint field [Fargo Customer Number|Fargo_x0020_Customer_x0020_Numbe] and then uses that to return both InvoiceNumber and ShipDate fields for the last 14 days.

The problem is the multiple record selection field I mapped it to only shows the invoice number and not the Ship Date.  In the Query portion I've tried a SELECT clause to select both InvoiceNumber and ShipDate, but that doesn't work against the custom API.  The Database to SharePoint Column Mapping only shows two mappings, one for the Database column I am mapping, the other for the ID Column.  It doesn't appear that I can map the Ship Date column in addition to Invoice Number, it can only access the one (Invoice Number) and an ID column. (This makes sense because it is multiple selection - the logic breaks when you have two multiple selection columns I am guessing, otherwise not sure why Single records can write to multiple mappings but not Multiple Records)

I am trying to find a way to return both ShipDate and CustomerNumber in the selection field but am unfamiliar with how to get this to work in the select query as I have only been able to get GetInvoices:CustomerNumber to work here against our custom API.  I have thought maybe a Form Event action to write all returned values to multiple list items on a separate list and create a look up to view them on my form, but I haven't figured out a way to make that work either.