Proforma Data Connection Azure

[Deleted user]

With Data Connection can we establish connection to Azure with REST API and auto populate any field in the Form with the API request ? If possible kindly share the way for dynamically populating filed based on Azure REST API Query.   

[Peter Preston]

Hi @[deleted] - there are instructions on data connections here:

http://links.thinktilt.net/data-lookups-tutorial

If that doesn't help, please @mention me in a reply here and I'll see what more we can do.

[Deleted user]

Hello @Peter Preston  Thanks for the response and sharing the link . I am able to establish connection with Azure using URL  (https://login.microsoftonline.com/{{tenantid}}/oauth2/v2.0/token) and with basic authentication method . But it is unable to configure the required information from the data , since the output format is not  in Json with the below error .

Unsupported Data Format

This data connection returned data in a format that is not currently supported. ProForma only supports JSON at this time.

It would be helpful if there is any better way to query the list of Resource Groups in  the Azure subscription by using Data connection of Azure Rest API method . 

[Andrew Daniels]

Hi @[deleted] 

For data connections to work, the data source to connect to needs to be in a JSON data format. What is the format of data for the list of Resource Groups in  the Azure subscription?

Another important note to mention the for JSON data source is that the data connections code explicitly does not traverse arrays of arrays (lists). The array has to include objects. If it encounters an array with arrays in it then it will stop processing them at that point down in the tree.

Just to confirm as a check, if you set up a data connection with the source of “https://jsonplaceholder.typicode.com/users“, can you tell me what you see for options under the ID drop-down field?

Let us know how you go.

Regards,

Andrew.