Write a list returned from an API

Hi there!

Is there a way to write a JSON list returned from an external API into an Adalo table?

I need then to have a list inserted in the list (received from API) so the external collection is hardly a solution here, I assume.

Thanks!

Hi @Dmytro, have a look https://help.adalo.com/integrations/custom-actions. Or search the forum for Custom Action.
Note that there are some restrictions. We basically need a REST API - not all JSON is working. See: Can we use javascript in GET ALL results key?

As I mentioned on another thread, replies like this that sound “official” are really not helpful.

REST doesn’t even require JSON, try getting an image from a Google Place - the response is just an image. See also text, XML etc.

All REST APIs if they are RESTful (fulfil the principles). Most APIs that look RESTful are not.

Lists are hard.

a)

{
 {“People”:[“Amy”,“Bill”]}
}

b)

[
   {
      "Name":"Amy", "Town":"Oxford"
   },
   {
      "Name":"Bill", "Town":"London"
]

…because a tool has no idea what to call that field (a) or the element (b).

I think Nested Arrays might be fairly hard, as you point out. However, you could wrap the API call in an Integromat webhook and manipulate the JSON in there.

Would need to see what the list/array looked like to help further.

1 Like

@NigelG I was just trying to point @Dmytro to existing resources and what has been discussed already in this context :wink:

I was just trying to reframe the previous discussions as being fairly misleading :slight_smile:

“It has to be REST” is really “There are some constraints on the format of the JSON which are not fully documented but it does need to be JSON over HTTP”

.

1 Like

Is this expected to work via Custom Action and/or External Collection?

Thank you!

External collections require the API to be able to return an array for “Get All”. So I think you would have to use a Custom Action.

Is there a (workaround) way to save an arrey received from API via Custom Action?

I haven’t played with it enough to know. Will see if I can find an API to test out.

1 Like

I can give you an API to test with )

1 Like

That would be handly. DM ?

1 Like

That gives a 500 response?

Yes. Also returns a list.

TypeError
TypeError: 'NoneType' object is not subscriptable

Traceback (most recent call last)
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 2464, in __call__
 
    def __call__(self, environ, start_response):
        """The WSGI server calls the Flask application object as the
        WSGI application. This calls :meth:`wsgi_app` which can be
        wrapped to applying middleware."""
        return self.wsgi_app(environ, start_response)
 
    def __repr__(self):
        return "<%s %r>" % (self.__class__.__name__, self.name)
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 2450, in wsgi_app
            try:
                ctx.push()
                response = self.full_dispatch_request()
            except Exception as e:
                error = e
                response = self.handle_exception(e)
            except:  # noqa: B001
                error = sys.exc_info()[1]
                raise
            return response(environ, start_response)
        finally:
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 1867, in handle_exception
            # if we want to repropagate the exception, we can attempt to
            # raise it with the whole traceback in case we can do that
            # (the function was actually called from the except part)
            # otherwise, we just raise the error again
            if exc_value is e:
                reraise(exc_type, exc_value, tb)
            else:
                raise e
 
        self.log_exception((exc_type, exc_value, tb))
        server_error = InternalServerError()
File "/app/.heroku/python/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
    import collections.abc as collections_abc
 
    def reraise(tp, value, tb=None):
        if value.__traceback__ is not tb:
            raise value.with_traceback(tb)
        raise value
 
    implements_to_string = _identity
 
else:
    iterkeys = lambda d: d.iterkeys()
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app
        ctx = self.request_context(environ)
        error = None
        try:
            try:
                ctx.push()
                response = self.full_dispatch_request()
            except Exception as e:
                error = e
                response = self.handle_exception(e)
            except:  # noqa: B001
                error = sys.exc_info()[1]
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request
            request_started.send(self)
            rv = self.preprocess_request()
            if rv is None:
                rv = self.dispatch_request()
        except Exception as e:
            rv = self.handle_user_exception(e)
        return self.finalize_request(rv)
 
    def finalize_request(self, rv, from_error_handler=False):
        """Given the return value from a view function this finalizes
        the request by converting it into a response and invoking the
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception
            return self.handle_http_exception(e)
 
        handler = self._find_error_handler(e)
 
        if handler is None:
            reraise(exc_type, exc_value, tb)
        return handler(e)
 
    def handle_exception(self, e):
        """Handle an exception that did not have an error handler
        associated with it, or that was raised from an error handler.
File "/app/.heroku/python/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise
    import collections.abc as collections_abc
 
    def reraise(tp, value, tb=None):
        if value.__traceback__ is not tb:
            raise value.with_traceback(tb)
        raise value
 
    implements_to_string = _identity
 
else:
    iterkeys = lambda d: d.iterkeys()
File "/app/.heroku/python/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
        self.try_trigger_before_first_request_functions()
        try:
            request_started.send(self)
            rv = self.preprocess_request()
            if rv is None:
                rv = self.dispatch_request()
        except Exception as e:
            rv = self.handle_user_exception(e)
        return self.finalize_request(rv)
 
    def finalize_request(self, rv, from_error_handler=False):
File "/app/.heroku/python/l

Does it need some application content param ?

The request format is
{“text” : “query text”}

Given I can’t get it to work in Postman, I don’t think Adalo is going to have much chance.

So … Content-Type = Application/json and I still get

I figured out everything and it works fine, thank you for your attempt to help!

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.