save Rest API JSON data in data entity

Follow

manoj jha

• March 21, 2020 16:49

Hi,

I am able to fetch API data from Two URLs but want to know how can I save it in database/DataEntity?

 

Thanks,

-Manoj

0

• 

  AgilePoint NX Support

  • March 22, 2020 15:27

  Hi Manoj,

  Could you please elaborate on your API response type(Name-Value or Multiple Value), also please let us know whether your response data is in an array?

  Currently, we are not supporting complex data in an array format to store in the data entity and only allow the single group of data.

  We would like to assist you in a better way to raise a detailed ticket from you in the AgilePoint Support Portal.

   

  Regards,

  AgilePoint Support.

  0

  Comment actions Permalink
• 

  manoj jha

  • March 22, 2020 18:41

  Hi Team,

  My API response data is as below:

  {
  "id": 00000,
  "name":"The xyz Group",
  "last_visited_at":"2020-03-17T20:46:53.000-04:00",
  "time_on_page":"20s",
  "pages_viewed":1,
  "source":"google.com / organic",
  "industry":"xxxx Services",
  "country":"United States",
  "state":"xyz",
  "city":"abc",
  "headquarter_address":"xyz ,abc, 101001,United States",
  "visited_pages":[
  "/"
  ],
  "website":"http://www.abcdef.com",
  "phones":[
  "+1 (000) 000-0000",
  "+1 (000) 000-0000"
  ],
  "emails":[

  ],
  "overview":"Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero's De Finibus Bonorum et Malorum for use in a type specimen book.",
  "approximate_employees":12456,
  "social_urls":[
  "https://twitter.com/abc",
  "https://www.facebook.com/abc",
  "http://www.instagram.com/organization/abc"
  ],
  "logo":"https://abc.abc.net/?v=2&q=https://xyz.xyz.net/static/cdac228a613003a3a8d662b240986d90_42df5d0cd5edf182b25c564dcf8951a09aece2d35fb6950fad19bb09386bcda3"
  },

   

  after saving this data and other API data I want to perform query/lookup operation on my saved data to find out any new data which is not matching in both datatable.

  How to create a ticket on this link https://agilepoint1.zendesk.com/ . I couldn't find the option of ticket creation. Please help me.

   

  Thanks,

  0

  Comment actions Permalink
• 

  manoj jha

  • April 15, 2020 19:21

  Hi Team,

  data is as above, and after 24 days I am still not able to save REST API in DataEntity. Please help me understand How can I save Rest API in DataEntity custom Entity.

   

  Thanks,

  0

  Comment actions Permalink

Please sign in to leave a comment.