Extract the value of a variable in an output

How To
1

Hello,

I make an API call in make, I have this kind of output :

Data:[{idClient:7fd0225a-db18-4f33-afe4-72b52211a3fe,numFactureTiers:f126c6-00059,statut:ERR_LIEN_PARTICULIER_PRESTATAIRE,errors:[{code:ERR_LIEN_PARTICULIER_PRESTATAIRE,message:Il n’existe aucun lien entre le particulier 7fd0225a-db18-4f33-afe4-72b52211a3fe et le prestataire 73072c76-b431-4c5c-a3a8-8f1fbd1f12d4 sur la période d’emploi de la demande de paiement 2024-08-01 / 2024-08-31,description:Il n’existe aucun lien entre le particulier 7fd0225a-db18-4f33-afe4-72b52211a3fe et le prestataire 73072c76-b431-4c5c-a3a8-8f1fbd1f12d4 sur la période d’emploi de la demande de paiement 2024-08-01 / 2024-08-31}]}]|

Is there an easy way to extract the value of “numFactureTiers” (f126c6-00059) ?
It doesn’t work with substring because the length of the output is not always the same.

Also, sometimes there is no “numFactureTiers”.

Thanks a lot for your help !!

Have a nice day !

2

Hey there,

this looks like a JSON string so you can use the Parse JSON module to get the values out of it.

Or alternatively use the Text Parser module to get the desired values using a regular expression

2 Likes
3

Thanks a lot Stoyan_Vatov, Parse JSON works perfectly !