Use JSON Advanced Connector to POST to an API

Hi there,
has anyone successfully got the JSON advanced connector to POST to an API, when using JSON data as parameters in a request body?
I've got a call working in Postman ok, but when I transfer it to DOMO I get an error: "Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try again."
I can get simple API calls working with the JSON No Code connector to the same API (it doesn't use credentials).
The data I'm trying to send looks like this:
{
"aggs": [
{ "oql": {
"and": [
{"field": ["page_group", "equals", "ADP"]},
{"field": ["day", "between", ["2020-07-13", "2020-08-27"]]},
{"field": ["is_crawled_intraday", "equals", "true"]},
{"field": ["url_is_resource", "equals", "false"]}
]
},
"value": "crawl_hits:sum",
"fields": [{"name": "day"}]
}]}
any help/insights would be appreciated.
Comments
-
Hi @simontarry76, if you haven't already, you should reach out to Support [support.domo.com] to have them look at it as well (and escalate to Dev if need be). They would be better suited to explore which part of the account credentials check is misaligning and causing the data to not come through.
9 -
You need to pass in the authentication headers. You can either do this an API/Developer token (More - Admin - Authentication - Access tokens).
You'd need to pass in the header value
X-Domo-Developer-Token: {TOKEN_VALUE}
Alternatively you can do this also with a client ID and secret from developer.domo.com
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive