Retrieving data with a GET API

Wappler General Need Help
1

Happy Holidays! I am trying to retrieve data from an API that is supplied with a url and authKey (see image)
image

It is a GET request that supposed to return a JSON array like this:
But, I have not figured out which API tool to use, or how to pass the information to generate a response. I have examples of how to use it with PHP and Python but would like to use the Wappler tools.

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "type": "array",
  "items": [
{
  "type": "object",
  "properties": {
    "SchoolName": {
      "type": "string"
    },
    "Address1": {
      "type": "string"
    },
    "Address2": {
      "type": "string"
    },
    "City": {
      "type": "string"
    },
    "State": {
      "type": "string"
    },
    "PostalCode": {
      "type": "string"
    },
    "Country": {
      "type": "string"
    },
    "Logo": {
      "type": "string"
    },
    "WebsiteUrl": {
      "type": "string"
    },
    "PhoneNumber": {
      "type": "string"
    },
    "DateJoinedIOGKF": {
      "type": "string"
    },
    "DateLeftIOGKF": {
      "type": "null"
    },
    "IOGKFMembershipValidThrough": {
      "type": "string"
    },
    "IogkfMembershipClass": {
      "type": "string"
    },
    "Instructor": {
      "type": "null"
    },
    "IogkfRegion": {
      "type": "string"
    },
    "EmailAddress": {
      "type": "string"
    }
  }
}
  ]
}
2

Did you tried this?

3

Yes. But it has added parameters that are used, and I cannot determine how do do that with the information I have. Like, do I put the authKey part as a header… or leave it as part of the URL. Is there there somewhere where I enter the provided schema?

4

Click on “Define API Schema”:

image
image1342Ă—836 150 KB

Regarding your authKey, it depends on the API documentation. You posted the image of it being passed as a query parameter in the URL… leave it that way.

5

I get this screen, when I click the “fetch schema” button nothing happens

image
image783Ă—742 21.4 KB

Do I define the fields provided in the schema example?

6

Here it’s working.

URL: https://viacep.com.br/ws/78055105/json/

image
image764Ă—726 56.3 KB

For an array response for testing, use https://jsonplaceholder.typicode.com/todos

1 Like
7

Thank you! It is working here. I did not open the the “Source” dialog.

image
image796Ă—743 29 KB

As soon as I did that, and clicked the :arrow_forward: icon, my data appeared. I just didn’t know where to look!!

1 Like
8

Nice!

Mark the conversation as “Solved”!

9

Are you Brazilian, @jrvidotti?

10

Yes! :brazil::brazil::brazil:

11

eu também! Vamos falar! abs!

12

I am still having issues with this. When I click the “Fetch Schema” button, then click the “Process” button, when in the schema editor it returns results in an array:

[{"SchoolName":" Unaffiliated / Honbo Dojo","Address1":" ","Address2":" ","City":"Spokane","State":"WA","PostalCode":"99202","Country":"USA","Logo":"https://members.iogkf-usa.com/noLogo.png","WebsiteUrl":"http://iogkf-usa.com","PhoneNumber":"509-309-2978","DateJoinedIOGKF":"2021-04-07T00:00:00","DateLeftIOGKF":null,"IOGKFMembershipValidThrough":"2021-12-31T00:00:00","IogkfMembershipClass":"IOGKF School","Instructor":null,"IogkfRegion":"West Coast\r\n","EmailAddress":"manage@iogkf-membership.com"},…

But when I try to create a repeat or table I get nothing. Is there another operation I need to run on the testing server (in my browser) I get nothing. What else must I do?