when trying that code i get:
Issue: invalid argument type(Table). Expecting a Record value instead.
I am not using a power automate flow but a custom connector in power apps. Here is the request and response of the connector as an example:
REQUEST
URL: https://msmanaged-na.azure-apim.net/apim/gpt-5ftest-5fe5e1fd276b03232e-5f58172779bbf487ab/7f961c90734b4b88820150f998d16cbd/openai/deployments/gpt-4-32k/chat/completions?api-version=2023-05-15
Method: post
Header: {
"Authorization": "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyIsImtpZCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyJ9.eyJhdWQiOiJodHRwczovL2FwaWh1Yi5henVyZS5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC8wZTE2MDliMC01ZTdmLTQ3MjItODYxMS1jN2YzMDY3Y2ViZGMvIiwiaWF0IjoxNjg2MDYzMDk1LCJuYmYiOjE2ODYwNjMwOTUsImV4cCI6MTY4NjA2ODUxOSwiYWNyIjoiMSIsImFpbyI6IkFUUUF5LzhUQUFBQStzVHVSWXdGZDdUd1k5a3FNOC81MVpIWHhUV05tcHZkQmNrT2twRHZTUnkrQUxHSWlEUXp2WEw5WnRHcGUyamwiLCJhbXIiOlsicHdkIl0sImFwcGlkIjoiN2RmMGExMjUtZDNiZS00Yzk2LWFhNTQtNTkxZjgzZmY1NDFjIiwiYXBwaWRhY3IiOiIyIiwiZmFtaWx5X25hbWUiOiJGbGVldCIsImdpdmVuX25hbWUiOiJNYXJrIiwiaXBhZGRyIjoiMjA4LjEyNy4yNDUuMTYyIiwibmFtZSI6IkZsZWV0IGpyLCBNYXJrIiwib2lkIjoiYjU3NTE1NjEtM2ZkZS00OTdiLTlhZmEtMGUxYTQyOWZlYTkzIiwib25wcmVtX3NpZCI6IlMtMS01LTIxLTg2OTAxNjkxMC0xNjYwNzg5NDAtNjIxNjk2MjE0LTczMzIzOCIsInB1aWQiOiIxMDAzN0ZGRTg2NzUwQzM0IiwicmgiOiIwLkFRY0FzQWtXRG45ZUlrZUdFY2Z6Qm56cjNGODhCZjZTTmhSUHJ2THVOUHdJSEs0SEFCby4iLCJzY3AiOiJ1c2VyX2ltcGVyc29uYXRpb24iLCJzdWIiOiI1NVZTbzRqdG02OTIxd0FRTFFXaU9NUWpJVER4YkxUYUpIX0VwV01sSkJzIiwidGlkIjoiMGUxNjA5YjAtNWU3Zi00NzIyLTg2MTEtYzdmMzA2N2NlYmRjIiwidW5pcXVlX25hbWUiOiJNYXJrLkZsZWV0anJAQk5TRi5jb20iLCJ1cG4iOiJNYXJrLkZsZWV0anJAQk5TRi5jb20iLCJ1dGkiOiI1WkFCRURxaVdFZV9nZURqczdSMEFRIiwidmVyIjoiMS4wIn0.Qy6ArhuyN4E6QYD9r8RVrZsaxiQPlQ1gZg4alpPFpw1rq8oIOF1D2S4vpZFrPB7r5gA3MUGHjCz9q3UIysnep0PYSWOnOhaO1HCWcLwa_Bl-QBhxtghXmMyYHsjp-ONM7rGhsindZpaRHJfNPNq-JPAuC-8wNSwXxrEi672vS0UMndJjYcNGOwuZ45KBTZoR_TXhoZAsNff7Yoj-KVElscNov63OHW1GoJTal6EGFYPX9bbC-o4LpmPZLsOkNdF33OpViDBGzyvg_k2WPzeRUS0Uo7yLnsSCd9jyRrlkZ7uR0TbrfQE_h5sPp-IRi78DHx7SpYtsmg4lhrRpzqx7OA",
"Content-Type": "application/json",
"api-key": "(removed for security)"
}
Body:
{
"messages": [
{
"role": "user",
"content": "How are you?"
}
]
}
Schema validation:
Validation succeeded
RESPONSE
Status: (200)
Headers:
{
"apim-request-id": "2ee9abb3-cbb4-4940-afef-ef0f614c85b0",
"azureml-model-group": "online",
"azureml-model-session": "aoai-gpt4-05222023-2",
"cache-control": "no-cache, must-revalidate",
"content-length": "398",
"content-type": "application/json",
"date": "Tue, 06 Jun 2023 14:57:34 GMT",
"openai-model": "gpt-4-32k",
"openai-processing-ms": "3893.9762",
"strict-transport-security": "max-age=31536000; includeSubDomains; preload",
"vary": "Origin",
"x-accel-buffering": "no",
"x-content-type-options": "nosniff",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"x-ms-client-request-id": "2ee9abb3-cbb4-4940-afef-ef0f614c85b0",
"x-ms-region": "South Central US",
"x-request-id": "a7e5ded4-54d7-4eda-a0d6-98e0464341b4"
}
Body:
{
"id": "chatcmpl-7OSPiRKmIb8ZNz0FId2WgxBIpyBPM",
"object": "chat.completion",
"created": 1686063450,
"model": "gpt-4-32k",
"choices": [
{
"index": 0,
"finish_reason": "stop",
"message": {
"role": "assistant",
"content": "As an AI, I do not have emotions or feelings, but I am here and ready to assist you with any questions or tasks you have!"
}
}
],
"usage": {
"completion_tokens": 29,
"prompt_tokens": 11,
"total_tokens": 40
}
}
Schema validation:
Validation succeeded
