Logic Apps Custom Connector with array query parameter - does it work?

De Raeve, Wouter 1

Hi,

I have created a logic app that connects to an API that uses a 'multi' collectionFormat in its query parameter...

See describing-parameters for more info...

I have defined this in my custom connector as follows:

        - name: subcalendarId[]
          type: array
          items:
            type: integer
          in: query
          required: false
          collectionFormat: multi

This works perfectly fine using a single subCalenderId, but as soon as I give it an array as input:

InvalidTemplate. Unable to process template language expressions in action 'Get_Events_Collection_or_Changes' inputs at line '1' and column '2897': 'Error reading string. Unexpected token: StartArray. Path 'queries['subcalendarId[]']'.'.

Anybody with any ideas?

ChaitanyaNaykodi-MSFT 24,666 Reputation points Microsoft Employee

2021-02-09T02:45:09.813+00:00

Hello @De Raeve, Wouter , Thank you for reaching out. I am currently working on the issue faced, I will share my updates soon.
ChaitanyaNaykodi-MSFT 24,666 Reputation points Microsoft Employee

2021-02-10T03:00:42.57+00:00

Hello @De Raeve, Wouter , apologies for the delay. Can you please provide additional information on how you are passing on an array to your action "Get_Events_Collection_or_Changes"? and are the elements of type "integer"?
Just one more thing can you please confirm if the "type" in the custom connector definition for parameter "subcalendarId[]" is array as shown below?
De Raeve, Wouter 1 Reputation point

2021-02-10T18:23:48.613+00:00
Hi, thanks for your answer. Currently I'm just using a manually initialized variable:

{"name": "subcals", "type": "array", "value": [8163630,8243701]}

Which is then passed on.

"queries": { "subcalendarId[]": "@variables('subcals')" }

Logic app custom connector parameter is looking like this:

]1
De Raeve, Wouter 1 Reputation point

2021-02-10T20:35:32.453+00:00

Hi @ChaitanyaNaykodi-MSFT thank you for your answer
De Raeve, Wouter 1 Reputation point

2021-02-10T20:36:22.927+00:00

The API for which the Logic App Custom Connector is created:

apidocs.teamup.com
ChaitanyaNaykodi-MSFT 24,666 Reputation points Microsoft Employee

2021-02-11T17:01:41.257+00:00

Hello @De Raeve, Wouter , Thank you for providing the additional details, I was able to reproduce the error. I have reached out to the team internally and will provide an answer as soon as I get a response back from them. Thank for your patience through out the process!

1 answer

ChaitanyaNaykodi-MSFT 24,666 Reputation points Microsoft Employee

2021-02-12T18:21:48.547+00:00

Hello @De Raeve, Wouter , my sincere apologies for the delay. I got a response back from the team that the Array and Multi-Value query parameters feature is not supported. The work around suggested is to use an array parameter in the body instead, you can find the more information regarding the implementation here, you can also refer to this Open Api definition used.
Please let me know if there are any additional concerns, I will be glad to continue with our discussion. Thank you!
Please sign in to rate this answer.
De Raeve, Wouter 1 Reputation point

2021-02-12T21:39:38.48+00:00

@ChaitanyaNaykodi-MSFT Thank you for confirming.

IT is unfortunate as it is perfectly valid Swagger 2.0 spec.
Any changes to start migrating to OpenAPi 3.0, or 3.1 which was just released?
Sign in to comment