For an example of how to use this new import, check out this Python project I built that imports completed Jira stories for a specified user. Before we had the Standard Import, we had to try to find this information through Jira and manually pull all the Jira tickets into a Lucid document for a user.

However, now that we have the Standard Import, this script can do all of that automatically. All you have to do is input the email of the Jira user, the year you want stories for, and which Lucid product you want to import them into. Then, the Python script will organize the stories by quarter and create a Lucid document for you.

This script has been super helpful for us going into year-end performance reviews so that we can see what work has been completed for each engineer on our team!

I created a document but page and shape data is getting ignored in my api calls, is there anything I can do to debug? I get a success message on the call. 

Hi @jstockwell, thanks for following up in this post! Just to make sure we’re understanding your issue correctly, are you seeing an issue with none of your shapes/pages appearing when you’ve imported your JSON file or are you not seeing Custom shape and page data? Is it possible for you to share the format of your JSON file that corresponds to the issue? 

This will allow us to take a closer look at what you’re experiencing! Thanks!

thanks, I have tried to copy the example in the JIRA example in the pinned post. I get a new document created with the correct title, but the page doesn’t get renamed and none of the shapes appear. 

{
  "version": 1,
  "rules": s],
  "collections": s],
  "title": "Main Plan",
  "pages": s
    {
      "id": "page1",
      "title": "Main Plan",
      "shapes": s
        {
          "id": "swimlane1",
          "type": "swimLanes",
          "boundingBox": {
            "x": 0,
            "y": 0,
            "w": 1280,
            "h": 155
          },
          "style": {
            "fill": {
              "type": "color",
              "color": "#ADD8E6"
            },
            "stroke": {
              "color": "#000000",
              "width": 2,
              "style": "solid"
            }
          },
          "magnetize": true,
          "vertical": true,
          "titleBar": {
            "height": 10,
            "verticalText": false
          },
          "lanes": s
            {
              "title": "Q1",
              "width": 320,
              "headerFill": "#ffffff",
              "laneFill": "#D3D3D3"
            },
            {
              "title": "Q2",
              "width": 320,
              "headerFill": "#ffffff",
              "laneFill": "#D3D3D3"
            },
            {
              "title": "Q3",
              "width": 320,
              "headerFill": "#ffffff",
              "laneFill": "#D3D3D3"
            },
            {
              "title": "Q4",
              "width": 320,
              "headerFill": "#ffffff",
              "laneFill": "#D3D3D3"
            }
          ]
        }
      ]
    }
  ]
}

Another good resource to use if you want to use the standard import to create BPMN diagrams is this open source script my team and I created. It takes the route to the BPMN/XML file (or entire directory) you want to import, reads it, transforms it into the JSON format the standard import uses, and then makes the request to the API. This is still a work in progress but we are confident on how useful it is in it's current state!

Hi, @jstockwell , thanks for reaching out about the new Standard Import! I’m a developer on the team that built the import and can help you debug what’s going wrong. Me and a few of the engineers on my team just tried the import with the JSON that you sent over above and want to make sure we’re seeing the same thing as you. 

This is a screenshot of the document that we got: 

To get that doc:

1. I created a document.json file with the provided JSON in the post above
2. Compressed that single file into a zip archive
3. Renamed the zip archive to have the .lucid extension
4. And sent a POST request using Postman to the https://api.lucid.co/documents endpoint. Here is a screenshot of the body of the request that I sent so you can check that we’re sending the same thing:

   

   And here are the headers that I sent on that request:

   

    

Let me know if this matches what you are seeing and we can debug from there.

Hi, thanks for following up on this. I realised I’m missing the step of saving the json to a file/lucid document. I was trying to send the page and shape data as part of the body of the api data. I will try again with the file and see if this can resolve it. 

Glad that we were able to find the missing step! Let us know if you have any more questions.

Hi!

I am trying to use Lucid Standard Import to create a document and I am getting “badRequest” with the following details:

{
    "code": "badRequest",
    "message": "Bad or malformed request",
    "requestId": "6cfdf736169adfd9",
    "details": {
        "error": "Count: 1, message: Standard import file entry does not exist",
        "import_error_code": "invalid_file"
    }
}

What should I do to fix it ?

Thanks!

Hi tuantv, thanks for reaching out! The error you’re seeing matches one that we’ve listed in the troubleshooting section of our documentation for the Lucid Standard Import that can be found here:

https://developer.lucid.co/standard-import/#common-file-errors

It appears that the problem might be happening because you compressed the folder containing your files instead of compressing the files together as a group.

If this isn’t the case, could you share your file structure so we can look into it further?

Hello,
I am trying to replicate the file import steps and upload the example given above in this post using Postman and the endpoint: https://api.lucid.co/documents
I did save the JSON in a document.json file, zipped it  and followed your instructions as above:

Header:

Body:

When I send the request, I get an error, it looks like the file format is not recognized; I used “x-application/vnd.lucid.standardImport” as content-type for the file.
I am working on Windows and use the build in Zip feature to generate this zipped file.

The file that I import is here:
zipped example file

could you please advice?
Thanks !
 

Hi again,
I am trying the same import (same zipped file as above) using Python in GitLab:
 

import os
import requests

api_key = 'Bearer ' + os.environ.get("API_KEY")
import_endpoint = "https://api.lucid.co/documents"

doc = 'document.lucid'
files = {"file": (doc, open(doc, mode="rb"), "x-application/vnd.lucid.standardImport")}

# Headers for the request
headers = {
    'Authorization': f'{api_key}',
    "Lucid-Api-Version": "1",
    'Content-Type': 'application/json'
}

body = {"title": "Created Document",
   "product": "lucidchart"}

response = requests.post(import_endpoint, headers=headers, data=body, files=files)

# Check the response
print('Status Code:', response.status_code)
print('Response:', response.text)

The response:
Status Code: 400
Response: {"message":"Invalid Json: Unexpected character ('-' (code 45)) in numeric value: expected digit (0-9) to follow minus sign, for valid numeric value\n at lSource: (org.apache.pekko.util.ByteIterator$ByteArrayIterator$$anon$1); line: 1, column: 3]"}

Hi @eric_s , thanks for reaching out in this thread! Unfortunately, I’m unable to reproduce the error when I input the same values as you in your screenshot. 

However, I am able to reproduce it when the import type has been inserted in the description field (and not content type). Could you double check to make sure there is nothing inserted in your description field? You may want to uncheck and recheck the content-type field to see if that helps.

Our API team were able to locate the logs for that endpoint and have confirmed that we are receiving the application/octet-stream as the Content-Type from that request. We have not made any changes to that value, which indicates that this is likely an issue of Postman not sending the value correctly. 

In regards to your attempt at the import in Gitlab, could you try this with an Oauth 2.0 token instead an API key? I’ll also reach out to our API team to check this and will update here once we hear back. 

Hello
@Sylvia X 
Thank you!
The following Python code works as expected GitLab, both with the API Key and Oauth 2.0 :

import os
import requests

api_key = os.environ.get("API_KEY")

def uploadDoc(doc, access_token):
    print("Uploading doc {0}".format(doc))
    upload_url = "https://api.lucid.co/documents"
    headers = {"Authorization": "Bearer {0}".format(access_token), "Lucid-Api-Version": "1"}
    doc_name = doc.rsplit('.', 1)10]
    body = {"title": doc_name, "product":"lucidchart"}
    files = {"file": (doc, open(doc, "rb"), "x-application/vnd.lucid.standardImport")}
    return requests.post("https://api.lucid.co/documents", headers=headers, data=body, files=files)

doc = 'document.lucid'
response =  uploadDoc(doc, api_key)

# Check the response
print('Status Code:', response.status_code)
print('Response:', response.text)

Hi @eric_s , thanks for following up here. It seems like this is working for you now. If this is not the case and you need further support, please let us know.