Skip to main content

I have to parse the below JSON GET response to get “email” and "is_valid_format.value” as columns in Json Call step with Data Streams, How can I perform this?
 

{

    "email": "xxxx@abc.com",

    "autocorrect": "",

    "deliverability": "DELIVERABLE",

    "quality_score": "0.99",

    "is_valid_format": {

        "value": true,

        "text": "TRUE"

    },

    "is_free_email": {

        "value": false,

        "text": "FALSE"

    },

    "is_disposable_email": {

        "value": false,

        "text": "FALSE"

    },

    "is_role_email": {

        "value": false,

        "text": "FALSE"

    },

    "is_catchall_email": {

        "value": null,

        "text": "UNKNOWN"

    },

    "is_mx_found": {

        "value": true,

        "text": "TRUE"

    },

    "is_smtp_valid": {

        "value": true,

        "text": "TRUE"

    }

}

Hi Aiwalia,

Try to add the stream and the attributes 

Also make sure the request/response debug file is available to help you in Headers>Advance>scroll to Debug


Thanks fbarretto,
I made these changes but I am getting an error in score columns- “WLA_TARGET_UNREACHABLE”. I searched through the documents for this error but did not find anything to understand where the issue is; can you please help me understand this error.
Thanks in advance :)


Hi Aiwalia,

It seems the request can’t reach the url in the configuration (check the logs I mentioned in the first reply); check if the url is correct and its input.

input example 01 ( in url; ‘%’ indicates the beginning and ending of a variable in URL and make sure it concatenates correctly, in this case with ‘&’)

input example 02 ( input template)

 

note about variables in url and  template

 


Thanks fbarretto,
It worked after adding % for variables.
Thanks a lot for your help


Hi All,

 

I have a question about the connection.

I had given the url to connect in the url section, and in the http headers section, I had given the Authorization in Name and credentials in value.
The same thing works in Postman but not in JSON calls.

Please make any suggestions.

 

Thanks

Avi

 


.


Reply