Podio API Documentation

Importer: Import app items

POST /importer/{file_id}/item/app/{app_id}

Imports the file into the given app. The mapping value for a field depends on the type of field:

date

{
  "start_column_id": The id of the column to map to the start value,
  "stop_column_id": The id of the column to map to the stop value, if any,
  "day_first": True if the importer should expect the day to be first, false otherwise
}

 

money

{
  "value_column_id": The id of the column to map to the value,
  "currency_column_id": The id of the column to map to the currency, if any,
  "currency_default": The default currency, if any
}

 

app

{
  "app_id": The id of one of the referenced apps the sub items should be imported into,
  "mappings": The mapping of the fields in the app to, exactly like this operation
}

 

contact

{
  "mappings": The mappings of the fields on the contact
  [
    "field_key": The key for the field on the contact,
    "unique": True of the value for the field is unique, false otherwise,
    "column_id": The id of the column to be used for the given field
  ],
  ... (more fields) 
}

 email

Mapping in form of:

{
  [numeric column id]: ["home"/"work"/"other"],
... more mappings
}
 

phone

Mapping in form of:

{
  [numeric column id]: ["mobile"/"work"/"home"/"main"/"work_fax"/"private_fax"/ "other"]
}

 

location

Mapping in form of:

{
[numeric column id]: ["value"/"lat"/"lng"/"street_number"/"street_name"/"postal_code"/"city"/"state"/"country"/"street_address"]
}

others

{
  "column_id": The id of the column that should be matched to the field
}
Usage
PHP Client
PodioImporter.php
PodioImporter::process_app( $file_id, $app_id, $attributes = array() );
Parameters
file_id*
Required.
app_id*
Required.
Request { "app_id": The id of the app the values should be imported into, "mappings": The mappings between fields and columns [ { "field_id": The id of the field in the app, "unique": True of the values for the field is unique, false otherwise, "value": Which value should be mapped for the field, depends on the type of field }, ... (more fields) ], "tags_column_id": The id of the column to read tags from, if any,
"app_item_id_column_id": The id of the column to read the app item id from, if any }
Response { "batch_id": The id of the batch handling the import }

Sandbox

The sandbox only handles GET operations for now.