Getting "Please Login" message when trying to use API Token

1

I’m trying to test in Postman using the API token from one of my Kintone apps.

I’ve tried to follow the docs as closely as possible, but I am unsure what I’m missing. I want to pull the records from the App to view.

URL: https://INSERT_SUBDOMAIN.kintone.com/k/v1/record.json?app=INSERT_APPID

And then I have:
X-Cybozu-API-Token:INSERT_API_TOKEN

Type Basic Auth

{  
 "code": "CB\_AU01",  
 "id": "5lWI0Q80ERRxOsenuzVk",  
 "message": "Please login."  
}
2

Hi Heather,

When using Postman, I did not see the message "Please login."

I believe the error may have occurred due to the following reasons:

  1. Incorrect Parameter: Please double-check the URL.

  2. API Token Not Updated: Ensure you click "Update App" after the API token is generated and saved in the Settings.

Here's how I configured it in the Postman settings:

  • Add key X-Cybozu-API-token and the value of the generated API token under the "Header" tab.

To retrieve all the records, you will need to add an "s" after "record" in the URL as shown below:

Get All Records
https://SUBDOMAIN.kintone.com/k/v1/records.json?app=210

To retrieve a single record, ensure the record exists in the app. Here is the URL:

Get One Record
https://SUBDOMAIN.kintone.com/k/v1/record.json?app=210&id=1

Thanks,

Junko

3

Hello! Thanks Junko! This is great! I got a successful return in Postman - but I’ve also switched to Basic Authentication. This will apply also, I’m assuming?

 

Thanks again!

~h

4

Hello Heather,

I am glad you got the problem solved.

Please refer to the following link for User Authentication.
There is a section explaining Basic Authentication in the link as well.

Kintone REST API Overview > Authentication - Kintone Developer Program

Thank you,
Yasu

5

I’ve still got an issue with this - not sure if you can help me - but I figured I’d at least try. 

So I’ve got Basic Authentication set up correctly and have tested in Postman - all works great. I am now trying to do the same exact thing in Power BI. I’ve outlined the issue here: https://community.powerbi.com/t5/Desktop/Authentication-Required-Remove-this-step/m-p/471628#M219152 

 

would you have ANY idea why it won’t accept the ‘?app=210’ part of the URL? I know this isn’t your area specifically - but I’m kind of desperate to try and get this working. So I’m trying everything.

If you can’t - completely understand. Thanks! :slight_smile:

 

6

Hi Heather,
I have never used Power IB before, so I installed it and included the following info on the set-up “From Web” screen.

Somehow, I did not see “Access Web content” screen and was able to get the data below successfully  .


What I realized is that if I input the wrong URL, I was navigated to “Access Web content”. Then as you said, under “Anonymous” tab, the URL does not have the full address as I specified but without “?app=154”(in my case). Therefore, I would suggest you to double check the URL on  “From Web”. Hope it helps.

7

I don’t get it. :frowning: My settings are the exact same as yours…  I’ve checked the URL - it’s the same exact one you listed in the earlier part of this forum. It works in my Postman (and in your’s). I have no idea…

 

Thank you for your help with this. At least I know it IS, indeed, possible. Something is off -  I just can’t figure out what

9

Thank you for your help - so much! :D 

~h

10

Hi Junko,

When you are adding the API token to the header, what it the Authentication method? I can only get this to work in Postman when using Basic Auth with Username: X-Cybozu-API-Token and the password as my API token.

 

thanks,

 

Nathan