Skip to main content

Data Quality & Catalog βš™οΈ

Discuss, learn, ask, suggest, share all things DQ&C πŸ”

  • 803 Topics
  • 2,043 Replies
803 Topics
Parse response from a Json Call

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"Β Β Β Β }}

Badge winners

  • First idea πŸ’‘
    sumithhas earned the badge First idea πŸ’‘
  • First idea πŸ’‘
    VanNguyenhas earned the badge First idea πŸ’‘
  • First idea πŸ’‘
    SusanShas earned the badge First idea πŸ’‘
  • 10 ideas πŸ’‘
    akumahas earned the badge 10 ideas πŸ’‘
  • First idea πŸ’‘
    romizhas earned the badge First idea πŸ’‘
Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, andΒ have an opportunity to shape the future of new products.

Read more