Data being altered with no visible difference in settings

[andrewstrealtor]

I am seeing two different results in the data being sent to my custom API when all settings are set to exactly the same in my workflows. I'm using

\r\n

as a carriage return in the data I'm submitting via a POST request and sometimes the data is altered to be

\\r\n

and other times it's only

\r\n

Look at these images showing the data I'm submitting and the resulting JSON data from the server receiving the POST. This is a problem! I've mentioned this before and you guys told me to ignore the slashes but the integration I'm sending it to needs the data specifically AS I'VE ENTERED IT. How do I send the data exactly as I see it without adding an extra slash before \r?

Data showing up correctly with a single slash version 1:

{
  "listings": [
    {
      "category": "Houses for Sale",
      "ad_title": "House for Sale in Crocus Meadows, Winnipeg",
      "mls_id": "202220449",
      "address": "170 Donna Wyatt Way",
      "city": "Winnipeg",
      "postalCode": "R3W0H6",
      "price": "499,900",
      "beds": "3",
      "baths": "4",
      "sqft": "1370",
      "description": "COPY AND PASTE THIS LINK IN BROWSER TO SEE ALL PHOTOS AND MORE INFO:\r\n\r\nhttps://www.andrewsthilaire.com/listings/170-donna-wyatt-way\r\n\r\nAddress: 170 Donna Wyatt Way, Crocus Meadows, Winnipeg\r\n\r\nPlease Allow 24 Hours Notice for Tenants Showings Start Aug 22nd, Offers Presented as received.\"Welcome To 170 Donna Wyatt Way\"Located in Lovely Crocus Meadows,Close to all Amenities.This Beautiful well cared fore Home features 1370 sq ft of Living space on 2 floors Plus another 600 sq ft of finished basement, Inviting front Foyer Entrance both Outside and Inside with a Large front Foyer Closet, leading to a Large Island Kitchen with seating for 4 at the Island, Quartz Kitchen Countertops, Gas Stove, Large Stainless Steel Fridge, Range Hood and Microwave, pantry with loads of space.Eating Area with Patio Doors Leading Out, Great Room with Feature Wall wired for a wall mount TV. The main Floor has a 2 PCS Bathroom, the 2nd floor offers 2 generous secondary bedrooms, Primary Bedroom features a 4 PCS Bathroom and a Large Closet.Fully Finished Lower Level with a bedroom, Rec Room,Laundry,storage, and Utility Room,Laminate Flooring.Large Fenced Yard,Deck, Storage Shed,Attached Front Drive Garage.\r\n\r\nContact me now for more details or to book a viewing!\r\n\r\nAndrew St. Hilaire\r\nKeller Williams Real Estate Services\r\n204-955-8496\r\nhttps://www.andrewsthilaire.com\r\n\r\nEach office is independently owned and operated.",
      "youtube": "https://www.youtube.com/watch?v=4Ly6JRJEhX4",
      "images": [
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd652727f28b0e9dd_202220449_0.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd65272daa2b0e9de_202220449_1.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd652727485b0e9eb_202220449_2.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd652721e94b0ea08_202220449_3.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd652722081b0ea09_202220449_4.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd6527257e5b0ea0a_202220449_5.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd65272ff6fb0ea0b_202220449_6.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4dd65272658fb0e9ec_202220449_7.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/6309ad4ed652723c27b0ea0d_202220449_8.jpeg"
      ]
    }
  ]
}

And here's version 2 with the same data and settings but it's adding an extra slash:

{
  "listings": [
    {
      "category": "Houses for Sale",
      "ad_title": "House for Sale in North End, Winnipeg",
      "mls_id": "202220973",
      "address": "588 Alfred Avenue",
      "city": "Winnipeg",
      "postalCode": "R2W1Y4",
      "price": "99,000",
      "beds": "2",
      "baths": "1",
      "sqft": "860",
      "description": "COPY AND PASTE THIS LINK IN BROWSER TO SEE ALL PHOTOS AND MORE INFO:\\r\n\\r\nhttps://www.andrewsthilaire.com/listings/588-alfred-avenue\\r\n\\r\nAddress: 588 Alfred Avenue, North End, Winnipeg\\r\n\\r\nShowing now, offers as received. Great starter home or revenue property! R2 zoning for further potential. 860 sqft with 2 bedrooms and 1 bathroom, newer shingles, pvc windows, HE furnace \\'07, full basement except under the back room which has a crawlspace but is accessible from the basement. Home and chattels sold \"as is\" and this should be written into any offers. Home needs approximately $10,000 of improvements for an electrical panel, some wiring and plumbing for water supply lines. It was renting for $900/month. All measurements are +/- jogs and lot dimensions from WPG property assessment.\\r\n\\r\nContact me now for more details or to book a viewing!\\r\n\\r\nAndrew St. Hilaire\\r\nKeller Williams Real Estate Services\\r\n204-955-8496\\r\nhttps://www.andrewsthilaire.com\\r\n\\r\nEach office is independently owned and operated.",
      "youtube": "https://www.youtube.com/watch?v=7KU4XCHY4Wk",
      "images": [
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24e049819935b_202220973_0.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24e7fd719935d_202220973_1.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24e3979199360_202220973_2.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24e391519935c_202220973_3.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24e747419935e_202220973_4.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda84acc24e48b7199395_202220973_5.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24ebe50199361_202220973_6.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda83acc24e44b519935f_202220973_7.jpeg",
        "https://uploads-ssl.webflow.com/5f16134bab224ce351d21258/630bda84acc24e49c9199394_202220973_8.jpeg"
      ]
    }
  ]
}

 

[Pabblymember11]

Hey @andrewstrealtor

Could you please share the name of the workflow in which you are performing the given API?

So, that we can look into it and can guide you accordingly.

 

[andrewstrealtor]

The two workflows in which the data seems to be inconsistent are called "Send new listing to KIJIJI APP" and "MANUAL - Send new listing to KIJIJI APP". I need the data to be sent exactly how I see it in Pabbly without the system adding slashes. I need an option to choose that will not alter the data in these workflows. I've tried both TEXT and JSON format options as well as Simple Response on and off and no matter what the data keeps being changed. The integration I'm sending to requires no slashes added to URLs and no slashes added to \r\n. \r\n is being changed to \\r\n in "Send new listing to KIJIJI APP" but in the MANUAL other workflow it's sending correctly as just \r\n but only sometimes and it keeps changing randomly. I need this fixed and set permanently somehow.

 

[andrewstrealtor]

Have you seen what I'm saying? Any solution?

 

[andrewstrealtor]

Anyone?

 

[Neeraj]

On our front-end builder, we use a TinyMCE text editor which sometimes creates issues related to what you mentioned for complex APIs.

In cases like these, there is an alternative that you can do:

You can fire the same API by creating a custom backend endpoint with all the dynamic fields.

You can go to:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

And create an action endpoint for your custom API call. All your dynamic values that require mapping will be created like the simple text fields on where you can simply map the values.

The full documentation is here:

Application Integration Guide for Developers

This article explains the process of integrating your apps in Pabbly Connect.

forum.pabbly.com

Do try it once and In case you need any help, do let me know here. Please make sure to provide your entire API call so that I can do it for you incase you are not able to do it yourself.

 

[andrewstrealtor]

I have no idea what you're instructing me to do. The data should not be altered from how I've entered it. Why don't you fix the issue please?

 

[andrewstrealtor]

Can you please help me further. The link you shared has about 10 separate tutorials. Which one do I need to follow?

 

[Pabblymember11]

Hey @andrewstrealtor

We are working over your concern and shall update you soon.

Please note that it will require a bit of testing at our end before we can provide you more information on the same

 

[andrewstrealtor]

You told me to create an app and said there were instructions on the page you provided but there are multiple tutorials. You said to let you know if more help was needed and I’m letting you know I need more help. Which tutorial should I be following to create this app to set things up so data isn’t altered?

 

[Pabblymember11]

Hey @andrewstrealtor

Meanwhile, we check on your concern, you can also try to create an app and action accordingly at your end.

Our comprehensive developer guide will help you through every step of building a solid app for your API and creating a great experience for your users.

Please go through all guides carefully and start working on creating your apps - https://forum.pabbly.com/forums/pabbly-connect-app-integration-guide/

 

[andrewstrealtor]

Are you saying I need to follow all these tutorials to set up an app to fix a single issue that shouldn't exist in the first place? I want to send data without it being altered by your systems. I could just as easily send an email but I want to use an API POST request properly without alterations. Why can't I do this using the text format?

 

[Pabblymember11]

Hey @andrewstrealtor

Our tech team is working on a workaround and shall update you soon.

Your kind patience will be appreciated!

 

[Chetali]

Hey @andrewstrealtor!

We have figured it out, it seems you were replacing the double quotes with the \" in the 19th step and which was creating a mess. Now, we've made changes in your workflow: https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZiMDYzZjA0MzY1MjY5NTUzNSI_3D_pc at step 19 (Text Formatter by Pabbly : Replace Text) and replaced double quotes ( " ) with single quotes ( ' ). It should work.

Kindly re-execute the concerned task history once and let us know if it works for you.

 

[andrewstrealtor]

The reason we CANNOT change " into ' is because " is an abbreviation for inches just as ' is an abbreviation for feet. I'm using Pabbly for integrations dealing with real estate listings. If a measurement such as 5 feet 10 inches is abbreviated as 5'10" then you CANNOT replace " with '. The issue is not with quotes anyways, the issue is extra slashes being added in from of \r becoming \\r randomly. Sometimes it doesn't happen. Why do I have two workflows with the exact same setup producing different results? For example, Workflow "Send new listings to KIJIJI APP" adds the extra slash to \r making it \\r but workflow "MANUAL - Send new listing to KIJIJI APP" does not have this issue and it's using the same text reformaters and same custom API settings, yet the data is different when sent out from each workflow. Please DO NOT change anything on my front end workflows and please correct the issue with the data being inconsistent and altered. I can't set up multiple workflows if the data being sent is different randomly like this. Your solution didn't fix the issue anyways.

 

[Pabblymember11]

Hey @andrewstrealtor

Sorry for the inconvenience but we would recommend you to replace double quotes with double single quotes('').

 

[andrewstrealtor]

That’s not an option. Please fix the data from being altered issue.

 

[Pabblymember11]

Hey @andrewstrealtor

We have checked with the technical team and as of now there is no workaround for the same. Although it is lined up but it will take a while before we come up with a resolution for the same.

 

[andrewstrealtor]

You've told me that the reason this is happening is because of TinyMCE but why is it that it happens on one workflow and not on the other one with the added slashes? If the system was consistent, I could work with it, but it seems to be different for different workflows while using all the same settings.

 

[andrewstrealtor]

Any idea when this will be fixed. My integrations are still having issues because sometimes the \r\n is sending as \r\n and other times it's sending as \\r\n. The receiving side of this integration cannot handle the variation and randomness. I don't understand why it can't be the same output when I'm sending the same input.