Objective: A Microsoft SharePoint form (Nintex Forms for Office O365) is created to retrieve and store user entered data. Then the same set of data needs to be transformed and mapped with the target API endpoint data structure. Then before invoking third party API, a proper URL for the API POST request would need to be created with the proper bearer token set.
Example of API POST request
Questions:
a) Is there any existing connector available to perform such operation such as extract data from SharePoint form, transform dataset, assemble API request query string, and then post the request using proper bearer token set.
b) Is there an option of creating custom connector in JAVASCRIT or TYPESCRIPT to develop above mentioned solution. If out of the box connector isn't available.
I think your question is covered by Step 6?
Thanks for sharing this link. I created a custom connector which accepts query parameters and then it will call the third-party API with POST action. Now my next step is to create a flow and test it by entering the parameter values manually. Then I need to find out how I can pass the values to these parameters programmatically to the custom connector. Do I need to write another custom connector to pass parameter values? Is there any example or link you can share? Thank in advance!
Thanks for the clarification. So, while building custom connector, it does provide you an optional step for custom code. i.e. '5. Code'. What is the purpose for this step? It also provides you the Swagger editor option as well. So, when to you such options? Since I am new to power automate and have never created custom connector. I need to understand the design flow and the necessary step needed without using any custom language code, if everything is possible without using code.
In my scenario, the first step is to extract SharePoint form data, which my developer has already done that, but then the data needs to be assembled in a Query string parameter (key/value pair) before submitting to third party API with POST action. Please let me know if there is any existing connector available or I need to create one from scratch as custom connector?
There isn't really a language involved unless you want to call Swagger a language.