Parsing string from chatgpt to JSON via backend flow?

Need help APIs
1

Has anyone created an integration via chatgpt and parsed the returned string into a JSON object?

I’m sending a request to chatgpt to do some matching of data, and below is an example of the response:

{
“matches”: [
{
“job_experience_id”: “1689329367501x788314122069369000”,
“job_requirement_id”: “1689348552446x342489591321560000”
}

However since its returned as a string, I can’t do much with it in the backend. Anyone have a plugin or workaround?

2

Send this string to another backend API and now it’s a json
String should be valid json format though

3

Do you have an example? Otherwise I’m just sending a string formatted like JSON to another backend workflow

4
  1. Create new backend api with ‘detect request data’
  2. Go to api connector and create new post api call with<body>in it.
  3. Initialise endpoint from step one from API connector with string that you have
  4. Use api call from step 2 in backend workflow that gets you this string

Now you have json data in step 1 and you can do anything with it.

4 Likes
5

Thank you so much! Going to try this when I’m home from work. I’ll let you know how I get on :slight_smile:

1 Like
6

Quick update, no data is shown as part of the initialisation

image
image3584×1992 199 KB

7

Send the string example

8

{
“matches”: [
{
“job_experience_id”: “1689329367501x788314122069369000”,
“job_requirement_id”: “1689348552446x342489591321560000”
},
{
“job_experience_id”: “1689329382817x868517141105058600”,
“job_requirement_id”: “1689348558516x187528149109115420”
},
{
“job_experience_id”: “1689329395033x751874060828652300”,
“job_requirement_id”: “1689348558516x187528149109115420”
},
{
“job_experience_id”: “1689329478787x232571213811550980”,
“job_requirement_id”: “1689348556507x535121829031699700”
},
{
“job_experience_id”: “1689329490118x486318894036187800”,
“job_requirement_id”: “1689348556507x535121829031699700”
},
{
“job_experience_id”: “1689329537449x349308369656386560”,
“job_requirement_id”: “1689348542407x574418429502157700”
},
{
“job_experience_id”: “1689329564153x138826878674465080”,
“job_requirement_id”: “1689348542407x574418429502157700”
},
{
“job_experience_id”: “1689330028408x198518256244571520”,
“job_requirement_id”: “1689348544382x976954643289034800”
},
{
“job_experience_id”: “1689330040260x407716864682647900”,
“job_requirement_id”: “1689348546594x977863171386363500”
},
{
“job_experience_id”: “1689330051246x756507468524933400”,
“job_requirement_id”: “1689348548694x496448285847838300”
}
]
}

9

This is not a valid string for json
replace every ” with "

{
"matches": [
{
"job_experience_id": "1689329367501x788314122069369000",
"job_requirement_id": "1689348552446x342489591321560000"
},
{
"job_experience_id": "1689329382817x868517141105058600",
"job_requirement_id": "1689348558516x187528149109115420"
},
{
"job_experience_id": "1689329395033x751874060828652300",
"job_requirement_id": "1689348558516x187528149109115420"
},
{
"job_experience_id": "1689329478787x232571213811550980",
"job_requirement_id": "1689348556507x535121829031699700"
},
{
"job_experience_id": "1689329490118x486318894036187800",
"job_requirement_id": "1689348556507x535121829031699700"
},
{
"job_experience_id": "1689329537449x349308369656386560",
"job_requirement_id": "1689348542407x574418429502157700"
},
{
"job_experience_id": "1689329564153x138826878674465080",
"job_requirement_id": "1689348542407x574418429502157700"
},
{
"job_experience_id": "1689330028408x198518256244571520",
"job_requirement_id": "1689348544382x976954643289034800"
},
{
"job_experience_id": "1689330040260x407716864682647900",
"job_requirement_id": "1689348546594x977863171386363500"
},
{
"job_experience_id": "1689330051246x756507468524933400",
"job_requirement_id": "1689348548694x496448285847838300"
}
]
}
10

You can use it to initialise the endpoint, but on backend you will need to find&replace every ” with " before sending this string

11

Did you get this to work? I tried submitting this a JSON via the API connector and got the same empty response.
(really appreciate your help on this)

12

I did, do it like this and add Content-Type application/json

Screenshot 2023-07-20 at 17.41.09
Screenshot 2023-07-20 at 17.41.09974×822 55.4 KB

13

That worked! Thats amazing! Thank you so much.

I just need to figure out how to schedule an api call on this list.

14

Hey @sat_miha !

I seem to have some trouble getting the data to be used in a workflow. I’ve got the API connector to send the call and detect the data correctly. But whenever I want to create a list of things from it, nothing seems to happen. Do you know why this could be?

image
image3584×2064 688 KB

15

I got it working! I had to basically convert the response to raw text and then do the find and replace.

Massive help here, honestly this was the biggest blocker I was facing. Thank you a ton!!

1 Like