Parsing a JSON object from a webhook step

Hey @Vir Villalobos ,

First of all from which app did you got the JSON?

Hi @Vir Villalobos 

Code Zap step can be used to parse raw JSON: https://zapier.com/apps/code/help

Help links for parsing RAW JSON:

• Parse Raw JSON with JavaScript Code Step

Hi @jayeshkumarbhatia !

The app is Responsive/RFPIO. (https://www.responsive.io/)

Thanks a lot!

Hey @Vir Villalobos ,

You will to use Code by Zapier for making custom API can than formatting the data in table format.

Hi @Troy Tessalone ,

Thank you!

However, I’m stuck still as I am not able to get the JSON itself in Zapier...when I make the API request using a webhook (Custom Request>POST) I get the ‘raw body’ without any brackets or anything, I simply lose the structure of the object which I could actually parse.

I’m not sure where my error might be, or if I should try a different approach.

Here are some screenshots that might clarify what I’m trying to say:

This is how my response shows in Zapier
 

This structure is actually correct, but then when trying to loop through the answers.key and answers.value for each result (like for each question), the loop separates my data by commas, and since there are commas in the text itself, the separation is not right.

I’m trying to create a loop from fine line items step, looping answers.value and answers.key values, but ‘m not sure how to configure it right, as this is just creating a block of text with all the values separated by commas, so then trying to separate those becomes an error since there are also commas within the text itself...

I also tried to catch the response in another zap, but I still get the ‘raw body’ without the structure, so with this I believe I cannot use the JSON.parse function.

Could you please help me understand how I can actually grab the raw JSON in Zapier

Hey @Vir Villalobos ,

Webhooks by Zapier is an advanced approach and i will suggest you to hire a Zapier Certified Expert from here

Big thanks @Troy Tessalone and @jayeshkumarbhatia for your help! 

I was able to achieve what I needed using some Python code. Here’s the code if it’s ever useful for someone else: 

(the only input for the code step would be the auth token)

import requests

# Prepare the URL and the request body
url = "https://app.rfpio.com/rfpserver/ext/v1/answer-lib/search"
body = {
    "keyword": "*",
    "collectionList": ["Collection Name"],
    "limit": 50,  # Adjusted limit to fetch more items if needed
    "metadata": False,
    "cursor": "*"  # Adjust as needed to fetch specific pages or items
}

# Prepare the headers including the authorization token
auth_token = input_data.get('auth_token', '')  # Ensure this is fetched correctly
headers = {
    "Content-Type": "application/json",
    "Authorization": f"Bearer {auth_token}"  # Using the auth_token from input_data
}

# Make the POST request
response = requests.post(url, json=body, headers=headers)

# Raise an exception if the request was not successful
response.raise_for_status()

# Parse the JSON response
data = response.json()

# Assuming the items are under 'results' key in the response
items = data.get('results', [])

# Prepare the output as a structured object
output = {'rows': []}

# Loop over the items to extract answers and their key-value pairs for each question
for item in items:
    question_id = item.get('id')
    company_id = item.get('companyId')
    question_text = item.get('question')
    alternate_questions=item.get('alternateQuestions')
    owner=item.get('createdBy')
    tags = ", ".join(item.get('tags', []))  # Join tags to make them a single string

    # Loop through each answer in the answers list
    for answer in item.get('answers', []):
        answer_key = answer.get('key')
        answer_value = answer.get('value')

        # Append each answer as a new row in the output dictionary
        output['rows'].append({
            "Question": question_text,
            "ID": question_id,
            "Answer": answer_value,
            "Key": answer_key,
            "Tags": tags,
            "AlternateQuestions":alternate_questions,
            "Owner":owner
        })

# Print or return output based on your use case

Then a subsequent loop step to loop through each set of values and send the values to my table does the trick!