Solved

Error on Adding Data to Long Text Field

  • 24 September 2022
  • 3 replies
  • 136 views

Userlevel 6
Badge +1

Pipefy is rejecting a card creation based on the update for a long text field. The error doesn’t give me a lot to go on. Appreciate any thoughts on this.

 

ERROR FROM PIPEFY:

RuntimeError

Error Parse error on "7" (INT) at [1, 553]

 

Text added to Long text field

 

TEAM CE - Optimize KPI - Volume Mgt - Total Ticket Pool Size Dropped Below 50 Your data has met the Alert Conditions: less than 50.0 Week Ticket Created At matches "last 7 days" Report: INPUT: Ticket Pool Size - Total New Tickets by Request Date ( https://eu.holistics.io/dashboards/2199023262493-ce-team/?_e=2199023280138 ) Dashboard: CE Team ( https://eu.holistics.io/dashboards/2199023262493-ce-team ) Here are the records that meet the Alert conditions: (Max 100 rows of results) Week Ticket Created At 2022-09-19 00:00:00.000000 34

icon

Best answer by Roberto Chavarria 27 September 2022, 23:40

View original

3 replies

Userlevel 6
Badge +1

Found the solution to this. There were “ in the text which had to be escaped. 

Escaping them with one \ did not work. I’ve seen examples where someone has used \\\ (3 backslashes).

Are 3 backslashes necessary?

Userlevel 6
Badge +5

Hi there! If the request is being made via API, it’s necessary to escape those apostrophes, like you mentioned. On the user interface it’s ok to send this information the way it is since Pipefy parses the data. Via the API though, this parse has to be manually done by the person/bot that executes the request. 

 

Long story short, here’s an example of how to correctly input the data in a parsed way:

mutation{
updateFieldsValues(input:{
nodeId:12345
values:[{fieldId:"long_text_field123", value:"TEAM CE - Optimize KPI - Volume Mgt - Total Ticket Pool Size Dropped Below 50 Your data has met the Alert Conditions: less than 50.0 Week Ticket Created At matches \"last 7 days\" Report: INPUT: Ticket Pool Size - Total New Tickets by Request Date ( https://eu.holistics.io/dashboards/2199023262493-ce-team/?_e=2199023280138 ) Dashboard: CE Team ( https://eu.holistics.io/dashboards/2199023262493-ce-team ) Here are the records that meet the Alert conditions: (Max 100 rows of results) Week Ticket Created At 2022-09-19 00:00:00.000000 34"}]
}) {
clientMutationId
}
}

(see the “value” parameter)

Userlevel 6
Badge +1

Thanks @Roberto Chavarria  - appreciate the clear explanation.

Reply