Seeking Xano Expert for API Integration with Gladia.io and Database Update

Hello Xano community!

I am looking for an expert to assist me in integrating data from a Gladia.io transcription API into my Xano backend. The API provides speech transcription results in JSON format, and I need to extract and store specific fields from the response into my utterance table in Xano.

Project Details:

API Integration: I need help setting up a function that sends a GET request to the Gladia.io API and retrieves transcription results in a structured JSON format.
Data Extraction: The following fields need to be extracted from two collections in the API response:
- From the sentences collection:
  - speaker
  - text
  - language
  - start_time
  - end_time
  - confidence
  - channel
- From the sentiment_analysis collection:
  - sentiment
  - emotion
Data Structure: After extracting the data, the records from both collections should be combined and stored in the utterance table in my Xano database. Here is the schema of the utterance table:

{
"id": "integer",
"created_at": "timestamp",
"transcription_id": "integer",
"no": "integer",
"id_no": "text",
"speaker": "integer",
"sentiment": "text",
"emotion": "text",
"text": "text",
"channel": "integer",
"language": "text",
"confidence": "decimal",
"confidence_scoring": "integer",
"start_time": "decimal",
"end_time": "decimal"
}
Example Data Structure:
Here is an example of how the data should be formatted when added to the Xano database, combining fields from both collections:

{
"speaker": 0,
"text": "No, to dzięki, Dobra, na razie.",
"language": "pl",
"start_time": 231.17318,
"end_time": 232.35425,
"confidence": 0.9,
"channel": 0,
"sentiment": "positive",
"emotion": "happy"
}

If this is something you can help with, please let me know your availability and rates. I would love to discuss this project in more detail.

Best regards,
Grzegorz