CUSTOM CONNECTOR: Research and findings

[ericonline]

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!

[v-yuxima-msft · Accepted solution]

Hi @ericonline ,

Thanks for your information.

This is very helpful.

Best Regards.

Yumia

[ericonline]

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]

@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