Show response of a API in a table

MIT App Inventor Help
,
1

Hello Guys, I need some help

I have create two api and I need some help, because i never did something like this:

I have a api to get the payments like this:

{
    "status": "success",
    "data": [
        {
            "nome": "Diogo Manuel do Rosário Teixeira",
            "nif": "246470232",
            "preco": "20",
            "item": "OPplan",
            "data_fatura": "2025-02-22",
            "data_recibo": "2025-02-23",
            "recibo": 1,
            "document_filename": "Z:\\CeX (PT) _ Vender à CeX - Basket.pdf"
        },
        {
            "nome": "Diogo Manuel do Rosário Teixeira",
            "nif": "246470232",
            "preco": "20",
            "item": "OPplan",
            "data_fatura": "2025-01-22",
            "data_recibo": "2025-01-24",
            "recibo": 1,
            "document_filename": "C:\\Users\\teixe\\Downloads\\CV2024-POR-MOD.pdf"
        },
        {
            "nome": "Diogo Manuel do Rosário Teixeira",
            "nif": "246470232",
            "preco": "20",
            "item": "OPplan",
            "data_fatura": "2024-12-22",
            "data_recibo": "2024-12-25",
            "recibo": 1,
            "document_filename": "C:\\Users\\teixe\\Documents\\RECIBO TUPPERWARE.pdf"
        },
        {
            "nome": "Diogo Manuel do Rosário Teixeira",
            "nif": "246470232",
            "preco": "20",
            "item": "OPplan",
            "data_fatura": "2024-11-22",
            "data_recibo": "2024-11-28",
            "recibo": 1,
            "document_filename": "C:\\Users\\teixe\\Documents\\Recibo_Fevereiro_885.pdf"
        },
        {
            "nome": "Diogo Manuel do Rosário Teixeira",
            "nif": "246470232",
            "preco": "20",
            "item": "OPplan",
            "data_fatura": "2025-03-22",
            "data_recibo": null,
            "recibo": 0,
            "document_filename": "C:\\Users\\teixe\\Documents\\NOWO_202403_22981757_Q03099416_U.PDF"
        }
    ]
}

And I have another to get the document encripted tha is save in MYSQL.

Now, what I'm trying to do is:
Show the response of the first API in a table.
If recibo is 1, show a button so the client can download or see the document.

There is someway to make this?

Best regards to all

2

Show the tabke view.

You want to show all details in vertical view or horizontal view.? Each item in one box or evry item in one one box?

3

Hello @Spicy_Topics

I want to show like This:

Nome Nif Preço Data da Fatura Pago
Diogo Manuel do Rosário Teixeira 246470232 20 21-02-2025 Sim Ver Recibo
Diogo Manuel do Rosário Teixeira 246470232 20 22-02-2025 Sim Ver Recibo
Diogo Manuel do Rosário Teixeira 246470232 20 23-02-2025 Não

Is it possible to make something like this?

4

Yes certainly it is possible with table view extension, before that make into a list of list tha make into table view

[FREE] TableViewer - fully style customized to show table data - #694 by Kevinkun credit to @Kevinkun

5

Thanks @Spicy_Topics for the suggestion

Actually i did try use that but i didn't undestand how to put it work.

@Kevinkun and @Spicy_Topics How can i do this? there is some tutorial show how to convert the two API's response to a table ?

Best regards to all

6

Screenshot_2025-03-26-17-12-36-31_40deb401b9ffe8e1df2f1cc5ba480b12
Screenshot_2025-03-26-17-12-36-31_40deb401b9ffe8e1df2f1cc5ba480b12720×1612 183 KB

Something like this???

Screenshot_2025-03-26-17-15-37-43_40deb401b9ffe8e1df2f1cc5ba480b12
Screenshot_2025-03-26-17-15-37-43_40deb401b9ffe8e1df2f1cc5ba480b12719×1108 156 KB

Imagine this global json is coming from your api GET request, so move these block in when web1.got text amd in the place of get global json use get responseContent

7

@Spicy_Topics YES, that is correct.

Now the part that is more tricky is really to only show the button "Ver Recibo" only if the the "Pago" camp is true

But what you did show now is really a good start

8

I do not know what are you talking about? Id that word present in the above json? You can use if then block to have that condition while preparing the list

9

So if the "recibo" is 1 in the json, in the columm "Pago" is gonna show "Sim" for that line and in another columm, on the same table, gonna show a button to see the PDF file.

If the "recibo" is 0 in the json, in the columm "Pago" is gonna show "Não" for that line and the button doesn't show

10

In such case you have to use Dynamic table guide suggested by @TIMAI2 using CompCreator extension by the same @Kevinkun

Almost the same logic but you need to use if then logic to have a button based on the value as said in the desired key