Assistance Needed with Extracting Phone Field from JSON in Activepieces

[JP.C]

Hello team,

I am having trouble extracting a phone field from a JSON file. Currently, it’s generating an error, and I would like to ask for your help with this part of ActivePieces. My knowledge in this area is basic, so any guidance would be greatly appreciated.

I am attaching screenshots so you can see the issue in detail.

Thank you very much for your support.

Best regards,
JP

[kishanprmr]

Hello @JP.C ,

@JP.C

Please remove the manually typed phone number from the JSON body. It should appear as “whatsapp_phone”:“{{trigger[‘body’][‘submission’][‘Numero de WhatsApp’]}}”. Currently, it’s duplicating the number like “+50689578690+50689578690”, which is an incorrect phone number.

[JP.C]

Hello, thank you for the response! This part is resolved. Now I have another problem: I want to extract the client ID to send a flow in ManyChat. I used Data Mapper to extract just the ID: {{step_4[‘newProperty’]}}. When I paste it into the JSON, it gives me the following information: Property expectedjson(513). How can I correct this step? I appreciate any help you can provide.

[kishanprmr]

Can you share details for Advanced mapping step ?

[JP.C]

Hi

I am sharing the template for you to analyze: https://cloud.activepieces.com/templates/J2sdH3eO48jKxf0Z6S9Vv

I see that the error generated is due to the format of the ID that I am trying to add in the JSON.

[JP.C]

Done, I found the error; it was an issue with the quotation marks.

{
“subscriber_id”:“{{step_4[‘newProperty’]}}”,
“flow_ns”: “content20240611231348_045224”
}

[JP.C]

Hello, I have a problem with my logic. When a person registers through a form, it is not capturing the WhatsApp field. Attached is the error; The error is because the “whatsapp_phone” field is empty and it is expected to contain a phone number in a valid format. Here are the details of the error:

Error: Phone number has invalid format
Field: whatsapp_phone

Can someone help me resolve the issue? I have attached screenshots so you can see the steps I am taking.

Here is the code:

{
“response”: {
“status”: 400,
“body”: {
“status”: “error”,
“message”: “Validation error”,
“details”: {
“messages”: {
“whatsapp_phone”: {
“message”: [
“Phone number has invalid format”
]
}
}
}
}
},
“request”: {
“body”: “{\r\n "first_name": "",\r\n "last_name": "Lead F- Sitio WEB",\r\n "whatsapp_phone": ""\r\n}”
}
}

[kishanprmr]

What is the format of the phone number data coming from the form trigger? Is it empty, or does it have two different fields for the phone number and country code?

[JP.C]

This is the format that Webook gives me:

  "Email": "jp@monkeia.com",
  "Nombre": "Jose Mario",
  "Mensaje": "Quiero información de sus servicios",
  "WhatsApp": "+5068957" 

It has 2 fields:

• Country code
• Phone number