Hello Make Support Team,
I’m encountering a recurring issue in my scenario involving the Google Slides “Make an API Call” module. The error I receive is:
[400] Invalid requests[0].replaceAllText: The match text should not be empty.
This happens even though:
- My scenario successfully retrieves data from a Google Sheet.
- The presentation files are correctly created in Google Drive with personalized content.
- The replacement instructions are clearly defined in the
requests.replaceAllText
block.
Despite this, the scenario fails at the API call level. I’ve confirmed that the text mapping is correct, and I’ve even manually verified that the document contains the placeholder texts.
I’m attaching several screenshots to illustrate the flow and the issue.
Could you please help me understand:
- Why the system considers the match text empty, even when mapping appears correct?
- If there’s a better way to structure the body of the API request to avoid this?
- Whether there’s a built-in way to skip or ignore
replaceAllText
instructions when the value isnull
or empty? - here is the JSON code :
{
“requests”: [
{
“replaceAllText”: {
“containsText”: {
“text”: “{{prenom}}”,
“matchCase”: true
},
“replaceText”: “{{15.0
}}”
}
},
{
“replaceAllText”: {
“containsText”: {
“text”: “{{nom_de_naissance_de_votre_pere}}”,
“matchCase”: true
},
“replaceText”: “{{15.1
}}”
}
},
{
“replaceAllText”: {
“containsText”: {
“text”: “{{nom_de_naissance_de_votre_mere}}”,
“matchCase”: true
},
“replaceText”: “{{15.2
}}”
}
},
{
“replaceAllText”: {
“containsText”: {
“text”: “{{date_de_naissance}}”,
“matchCase”: true
},
“replaceText”: “{{15.3
}}”
}
},
{
“replaceAllText”: {
“containsText”: {
“text”: “{{date_du_jour}}”,
“matchCase”: true
},
“replaceText”: “{{15.11
}}”
}
}
]
}
Thanks in advance for your help!
Best regards,