-
No Code JSON Connector - Expecting a XML URL?
Hello Everyone, I started encountering this issue while using the No Code JSON Connector. "Domo is ready, but received no data from the provided XML URL. Please check the provided XML URL or even try limiting the returned data." Is there a reason DOMO started expecting XML instead of a JSON URL?
-
GET private aws s3 json obj in the 'JSON No Code OAuth' or 'JSON No Code' Connector
Hi everyone. I am looking to get a private aws s3 json file in the 'JSON No Code OAuth' or 'JSON No Code' Connector but haven't been able to figure out the authentication to aws. Has anyone successfully done this? Any ideas on how to do this?
-
Brick with Ten Datasets Question
Hey all, In the template for the "Brick with Ten Datasets", is there more specific documentation on the queries used to pull summary info into the card? https://developer.domo.com/docs/dev-studio-guides/data-queries For example, the link is provided as documentation for the code snippet below but there isn't even a…
-
Json Connector to only run when data is pushed to it.
Currently, there is no option to change the schedule for the JSON WebHook connector. Since this impacts the billing when the connector is running every 15 minutes regardless if data is pushed to it, I'm suggesting an option to toggle when we want the json connector to only run when data is pushed to it.
-
Allow empty datasets with future date ranges
We pull two years transactions plus the current year from an api using JSON connectors. I've found it more reliable and efficient to break the data into smaller pieces. For the past years, I have created a connector for each - refreshed once per month. For the current year, I am splitting the year into Q1, Q2, Q3, and Q4.…
-
Creating an HMAC and pushing data to a JSON Webhook connector with a secret applied
It can be a little confusing when trying to setup the JSON Webhook connector with a secret applied and push data successfully. The biggest hurdle can often be creating the HMAC to pass in through the header. Depending on the source that you're pushing from or what programming language you're using will change the setup…
-
Relative date range filtering using JSON no code with API only supporting timestamp format
Hello, I'd like to use our partner API within Domo with JSON no code connector The connexion works fine until I set up a relative date range filtering of 7 days (which is allowed by the API with startDate and endDate parameters). The API documentation specifies that date parameters should follow this timestamp format :…
-
No Code JSON Connector - help
Hi DOMO Gods, I've recently set up a NO code JSON connector to pull an endpoint from a CRM that we use. I worked with a DOMO consult to configure the pagination and parsing, so that we were able to get the data we wanted and it worked well for a few days, however I'm getting the following error message now for the last few…
-
Json No Code Connector - Question.
Hello Everyone, I am using Json No Code Connector to pull the data in the Replace mode. I would like to only replace data which is changed at the backend and not the whole data. Is there a way we can do this in Connector settings ? Or any other way ? Thanks,
-
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…
-
JSON Connector with JWT
I’m hoping to pull in some data from Prisma, they have a pretty standard API pass a username and password to /login get back a JWT token and then put that token in all further calls in a custom header field and have to login again after 10 mins. The main API is JSON (with quite a few arrays inside arrays) I notice a couple…
-
How to implement commands from the Command Line Interface Tool in Python, specifically api requests
Question: Is it possible to execute command line interface tool operations within Python, specifically the 'list-dataflow' command? Elaboration: The 'list-dataflow' command in the command line interface tool returns JSON structured metadata for a dataflow. My guess is that this command is just making a GET request to a…
-
DataFlow Transform (i.e. Action) Types in API JSON data
My question: What factors determine the type of a dataflow transform in the api JSON data (e.g. GenerateTableAction, SQL, SqlAction)? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a…
-
Timestamp Convention in JSON File from Command Line DataFlow Request
My question: Does anyone know DOMO's timestamp convention and how these map to normal timing conventions? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a filepath returns a json file to…
-
Domo User Name
Hello, maybe a silly question domo.env.userId This line gets the id for a Domo User, but how can I get the User Name?I'm recreating DP19 Advanced App Building Exercise and I'd like my app to have the username instead of the id, this will be helpful for when I create custom apps for my company Thanks in advance
-
Amazon DynamoDB Data ETL
My team recently began to transition one of our key source data systems to be housed on AWS DynamoDB. Our connection to the legacy system is cumbersome to say the least (e.g. use a custom powershell script, workbench, and csv to feed data to Domo)...So, I was excited to utilize one of Domo's API Connectors to DynamoDB,…
-
JSON with custom parsing pagination
I have a question regarding the JSON with custom parsing connector. I have a dataset using the pagination settings to find the next page based (I think) on the ID of the last row returned. If I set this dataset up for a regular refresh, will it look at the last ID in the dataset, or would it just restart from the…
-
No Code JSON - Upload File Containing JSON Data
I am getting the below error message when trying to manually import a JSON file using the no-code JSON connector. "Domo is ready, but there was an error parsing an expected JSON response from the API. Please check that the API is returning the expected data" I am using a JSON account with no parameters other than the name…
-
JSON No Code - Parse Issue
I'm connecting to Parallax API, but am running into Parsing issues. When I go to the parse section of the JSON Connector, I am able to fully parse out the data into the necessary format that I need, but when I run the connector there is a column that won't parse. In the preview the data looks like this: Pre-parse:…