cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

CUSTOM CONNECTOR: Research and findings

Entering my 3rd day straight on a complex GET/POST nested JSON schema problem. Thought I'd share some interesting findings I've found:

  1. A schema that returns "Success" in the Custom Connector "Test" area, does not directly transfer to a Custom Connector POST function ( myCustomConnector.POST({<things:andStuff>}) ) in PowerApps.
    1. This really sucks and its largely due, I believe, to 2.

  2. When dealing with POST schemas, " [ ] " 's <> work. The Custom Connector function needs "Table({<your schema here>}). It will not "see into" square brackets. 
    1. You can interrogate the needed schema by substituting [ for Table(, hover over the red squiggly intellisense, and build the correct schema from this. (handy but suuuuper-hacky).

Hope this helps!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: CUSTOM CONNECTOR: Research and findings

Hi @ericonline ,

 

Thanks for your information.

This is very helpful.

 

Best Regards.

Yumia

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: CUSTOM CONNECTOR: Research and findings

Hi @ericonline ,

 

Thanks for your information.

This is very helpful.

 

Best Regards.

Yumia

View solution in original post

Super User
Super User

Re: CUSTOM CONNECTOR: Research and findings

Adding on to this... kind of related. 

  • For a ClearCollect statement that does NOT use a Custom Connector-defined JSON schema, I'm UNABLE to use Table()!
  • I MUST use "[ ]" 's instead of Table()!
  • Weird.

Example:

  • Does not work:
  • ClearCollect(colSample,
        Table(
            {parameter: "test", paramValue: 123},
            {parameter: "toast", paramValue: 345},
            {parameter: "toots", paramValue: 567}
        )
    )
  • Does work:
  • ClearCollect(colSample,
        [
            {parameter: "test", paramValue: 123},
            {parameter: "toast", paramValue: 345},
            {parameter: "toots", paramValue: 567}
        ]
    )
    Hope this helps someone else too!
joshbooker
Level 8

Re: CUSTOM CONNECTOR: Research and findings

@ericonline 

 

I think this may have something to do with the fact that ability to add so-called 'tabular-capabilities' is absent in custom connectors.

 

See: https://powerusers.microsoft.com/t5/PowerApps-Ideas/Custom-API-with-tabular-capabilities/idi-p/13394

 

HTH,

Josh

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 314 members 6,143 guests
Recent signins:
Please welcome our newest community members: